Sub DoIt() Call fnTextBoxDefaultSearch("=CurrentUser") End Sub Public Function fnTextBoxDefaultSearch(sSearch As String) ' Search text boxes on all forms for =CurrentUser() function etc Dim frm As AccessObject Dim ctl As Control Dim sFormName As String For Each frm In CurrentProject.AllForms sFormName = frm.Name DoCmd.OpenForm sFormName, acDesign For Each ctl In Forms(sFormName) If ctl.controltype = 109 Then If InStr(1, ctl.Properties("DefaultValue"), sSearch) Then Debug.Print _ "** " & sFormName & " - " & ctl.Name & " - " & " _ ControlSource->" & ctl.ControlSource End If End If Next DoCmd.Close acForm, sFormName Next End Function |