Spell check in Access Memo

[Guest]

Is there some way to turn on automatic spell check and grammar check in a
memo field. Specifically, I'm wondering if the wiggly red line that denotes
an error in Word also can apply to memo fields in Access.

Thanks.
Bob

 

[Arvin Meyer [MVP]]

There is no grammar checking in Access. You can spell check using the
following:

Public Function Spell()
' Arvin Meyer 9/17/1998
' Adapted from code by Terry Wickenden
Dim ctlSpell As Control
Dim frm As Form
Set frm = Screen.ActiveForm
DoCmd.SetWarnings False
' Enumerate Controls collection.
For Each ctlSpell In frm.Controls
If TypeOf ctlSpell Is TextBox Then
If Len(ctlSpell) > 0 Then
With ctlSpell
.SetFocus
.SelStart = 0
.SelLength = Len(ctlSpell)
End With
DoCmd.RunCommand acCmdSpelling
End If
End If
Next
DoCmd.SetWarnings True
End Function

 

[Guest]

Thank you very much Arvin. I implementing this may be may be a bit beyond my
capabilities, but I'll try to see if I can figure out how to follow you
suggestion. In any case, your response is most appreciated.

Bob

 

[Allen Browne]

Just a warning, Bob.

If you are using Access 2007 with the Rich Text format for your memo fields,
DO NOT turn on automatic spell checking. You data will be corrupted where
the field contains carriage returns.

(Hopefully this will be fixed when MS released Service Pack 1 for Office
2007.)

 

[Guest]

Allen,
Thanks for your warning. I do have the rich text turned on in the memo
field and keeping it on is important for my database. I will follow you
advice, and not turn on the spell check until the SP is released. However,
my impression from the previous post was that there wasn't an option for
switching this on or off, but that I needed to introduce a macro. If there
is a switch, can you point out to me how to turn it on?

Thanks,

Bob

 

[Allen Browne]

I don't believe there's a switch for Access only.

(There are settings that affect how it works for all of Office, so you
probably don't want to mess with those.)

 

[Guest]

OK. thanks for your reply. I think the spell checker is one of the best
features in Office and thought it might involve some tricky programming, I
hope it will eventually be integrated into the Access memo field.

Thanks again.