Spell Check Capitals

  • Thread starter Thread starter Charles D Clayton Jr
  • Start date Start date
C

Charles D Clayton Jr

Does anybody know how to spell check capitals? I have used the code
DoCmd.RunCommand acCmdSpelling which works but not on capitals.
I know that you can physically go in to the spelling dialog box and
set the option but can you do this through code? Or can you check to
see if a user's options are already set and let them know that it will
not work for capitals?

Thanks,

Charles D Clayton Jr
 
Charles D Clayton Jr said:
Does anybody know how to spell check capitals? I have used the code
DoCmd.RunCommand acCmdSpelling which works but not on capitals.
I know that you can physically go in to the spelling dialog box and
set the option but can you do this through code? Or can you check to
see if a user's options are already set and let them know that it will
not work for capitals?

Thanks,

Charles D Clayton Jr
Click to expand...

See the help file entries for the GetOption and SetOption methods of the
Application object. You can check this option with code like this:

If Application.GetOption("Spelling Ignore words in UPPERCASE") = 0 _
Then
MsgBox "Note: words in upper case will not be checked!"
End If

I suppose you could do something like the following, but I'd be very
wary of it:

Dim fSpellcheckUppercase As Boolean

fSpellcheckUppercase = _
Application.GetOption("Spelling Ignore words in UPPERCASE")

If Not fSpellcheckUppercase Then
Application.SetOption "Spelling Ignore words in UPPERCASE", True
End If

' ... do your spell check here ...

If Not fSpellcheckUppercase Then
Application.SetOption "Spelling Ignore words in UPPERCASE",
False
End If

You'd want to set up error-handling to ensure that, if you changed the
user's option, there's no way the code can exit without resetting it to
the original value. I don't recommend this approach at all, though,
because something could always happen -- a crash perhaps -- that would
leave the user's option set incorrectly. You don't want to go monkeying
around with users' preferences without their permission.
 
Thasnks for the good information. Sometimes it can be very difficult
to find something in the Help System if you do not know it exists.

Charles D Clayton Jr
 
Back
Top