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.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
'---------CODE ENDS---------------
ca************@btinternet.com (Cassie Pennington) wrote in message news:<47**************************@posting.google. com>...
Is there a command to spell check fields in Access (probably in the
afterupdate event)?
Thanks in anticipation
Cassie