B
Bill B.
I just converted an A97 Database to A03. I now have a very slow Find. When I
uncheck the "Search Fields as Formatted" (SFaF) option, the find works very
well. How do I set the SFaF option off by default. The code that generates
the Find dialog is:
Private Sub FindRecord_Click()
On Error GoTo Err_FindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_FindRecord_Click:
Exit Sub
Err_FindRecord_Click:
MsgBox Err.Description
Resume Exit_FindRecord_Click
End Sub
uncheck the "Search Fields as Formatted" (SFaF) option, the find works very
well. How do I set the SFaF option off by default. The code that generates
the Find dialog is:
Private Sub FindRecord_Click()
On Error GoTo Err_FindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_FindRecord_Click:
Exit Sub
Err_FindRecord_Click:
MsgBox Err.Description
Resume Exit_FindRecord_Click
End Sub