rockysmolin at bchacc.com
rockysmolin at bchacc.com
Thu Mar 24 11:22:22 CDT 2011
Dear List:
I have a routine in an app which spell checks a field. There's a
command button that will go through all the records in the recordset and
spell check each record. Problem is that when it prompts for a
correction and the user clicks change or change all, the correction is
made but then the spell checking stops. Here's the code:
DoCmd.GoToRecord , , acFirst
Me.txtTimeEntryNarrative.Enabled = True
Me.txtTimeEntryNarrative.Locked = False
Do While Me.NewRecord = False
Me.txtTimeEntryNarrative.SetFocus
Me.txtTimeEntryNarrative.SelStart = 0
If Not IsNull(Me.txtTimeEntryNarrative) Then
Me.txtTimeEntryNarrative.SelLength =
Len(Me.txtTimeEntryNarrative)
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True
End If
DoCmd.GoToRecord , , acNext
Loop
Is there a workaround for this problem?
MTIA
Rocky