[AccessD] Spell Check Problem

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







More information about the AccessD mailing list