Results 1 to 2 of 2
  1. #1
    sabre1 is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Posts
    22

    Suppress spell check error message

    I have used a spell check on a field in my form and used this code on the after update:

    Private Sub (Field Name)_AfterUpdate()
    'If the textbox contains data run the
    'Spell Checker after data is entered.
    If Len(Me!(Field Name) & "") > 0 Then
    DoCmd.RunCommand acCmdSpelling


    Else
    Exit Sub
    End If
    End Sub

    However, if it returns no spelling errors it comes up with a message saying that there are no spelling errors. Is there anyway of suppressing that error message so it doesn't come up.

    Any help would be appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    isn't there an Access option somewhere in the 'popular' section and/or tab to automatically flag spelling errors in form controls with little colored boxes?? I believe the default is green. Would that work instead as an indicator??

    I don't know of course, but it doesn't make sense to me that you could check the result of that DOCMD you're using now. Although if you could, I would assume the returns would be 0 and 1.

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

Similar Threads

  1. Error Message
    By Juan4412 in forum Forms
    Replies: 5
    Last Post: 03-06-2011, 04:22 PM
  2. Error message when importing
    By ljenkins23 in forum Access
    Replies: 5
    Last Post: 06-10-2010, 09:30 AM
  3. error message
    By ngeng4 in forum Forms
    Replies: 85
    Last Post: 03-25-2010, 06:47 AM
  4. Code to spell out check amount?
    By spkoest in forum Access
    Replies: 4
    Last Post: 06-16-2009, 07:44 PM
  5. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 AM

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