Results 1 to 2 of 2
  1. #1
    scoe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    91

    Spell check on form fields not working

    I found some brilliant code for spell checking a form:
    [Private Sub YOURFIELDNAME_Exit(Cancel As Integer)
    Dim strSpell
    strSpell = FIELDNAME
    If IsNull(Len(strSpell)) Or Len(strSpell) = 0 Then
    Exit Sub
    End If
    With FIELDNAME


    .SetFocus
    .SelStart = 0
    .SelLength = Len(strSpell)
    End With
    DoCmd.SetWarnings False
    DoCmd.RunCommand acCmdSpelling
    DoCmd.SetWarnings True
    End Sub]

    It works perfectly in one database but not the one I need it to work in as it will not let you out of the field if there is text already there.... When the warnings are switched on it continually repeats that the spell check is complete but wont let you out of the field..... Would be grateful if anyone has any ideas.

  2. #2
    scoe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    91
    Seems this was due to the form having tabs, replaced code with a public function and it now works.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. trying to turn off spell check for sent emails
    By trevor40 in forum Programming
    Replies: 2
    Last Post: 02-13-2014, 08:05 PM
  2. Spell and grammar check
    By destroyer in forum Forms
    Replies: 1
    Last Post: 01-19-2014, 11:51 AM
  3. Replies: 10
    Last Post: 01-17-2013, 02:24 AM
  4. Suppress spell check error message
    By sabre1 in forum Forms
    Replies: 1
    Last Post: 03-24-2011, 09:58 AM
  5. Code to spell out check amount?
    By spkoest in forum Access
    Replies: 4
    Last Post: 06-16-2009, 07:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums