Spell check in Access

[Cassie Pennington]

Is there a command to spell check fields in Access (probably in the
afterupdate event)?

Thanks in anticipation
Cassie

[Alan Webb]

Cassie,
Should be. Spell check is there in Access if you press F7. I don't know
how you would code spell check so it does it all the time, though.

"Cassie Pennington" <ca************ @btinternet.com > wrote in message
news:47******** *************** ***@posting.goo gle.com...

Is there a command to spell check fields in Access (probably in the
afterupdate event)?

Thanks in anticipation
Cassie

[Phil.Latio]

Hi Cassie,

Copy and paste the function below into a Standard Code module.

Use the function in the AfterUpdate event, to fire the spool-chucker,
sorry, spell-checker ;-)

I must admit I got the code off some Group or Website, and it is not
my own work, however, it does the job within my application.

Hope that helps,

Phil

'---------CODE Begins---------------

Public Function fSpell()
Dim ctlSpell As Control
Dim frm As Form
Set frm = Screen.ActiveFo rm
DoCmd.SetWarnin gs 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.RunComman d acCmdSpelling
End If
End If
Next
DoCmd.SetWarnin gs True
End Function
'---------CODE ENDS---------------
ca************@ btinternet.com (Cassie Pennington) wrote in message news:<47******* *************** ****@posting.go ogle.com>...

Is there a command to spell check fields in Access (probably in the
afterupdate event)?

Thanks in anticipation
Cassie