By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Spell check in Access

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

Thanks in anticipation
Cassie
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.google.c om...
Is there a command to spell check fields in Access (probably in the
afterupdate event)?

Thanks in anticipation
Cassie

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.