Spell Check

[John]

Hi
On my form I have a memo field which I would like to be spell checked ( like
an MS Word Doc) is this possible.
My forms do not have access to the default menu bars and are set as Modal
and PopUp.

Regards

John

 

[Guest]

I don't want to sound as if I am being short or not wanting to help, however,
with that said, you might try doing a search within these newsgroups for what
you are needing.

I did a quick search for "Spell check" and the answer immediately came up.

Here is the answer from "Gunny", AKA '69 Camaro':

"Set focus to the control that you desire to spell check then use the
appropriate Runcommand argument. For example:

Me!txtComment.SetFocus
RunCommand acCmdSpelling

.... where txtComment is the name of the text box that needs to be spell
checked."

I'd say that 85 to 90 percent of the time when I need to quickly find an
answer, I can just search the existing newsgroup responces and I will find
exactly what I am looking for.

This is actually better that posting a new post and having to wait until
someone decided to take the time to answer. I usually can have my answer in
just a matter of a few minutes.

This is not to say that there are times when the answer is just not there
and a post is certainly in order.

Again, I do not want to discourage anyone from posting their questions, just
trying to incourage usage of existing info.

 

[missinglinq via AccessMonster.com]

Here' a complete routine. Just put the code behind a command button and
change

YourMemoBoxName

to the actual name of the text box that holds your memo field.

Private Sub MemoBoxSpellCheck_Click()
With Me!YourMemoBoxName
Me.YourMemoBoxName.SetFocus
If Len(.Value) > 0 Then
DoCmd.SetWarnings False
.SelStart = 1
.SelLength = Len(.Value)
DoCmd.RunCommand acCmdSpelling
.SelLength = 0
DoCmd.SetWarnings True
End If
End With