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

Spell check in access

P: 78
Is it possible to check the spelling in a form as people are typing in the form? The General Manager of my company is asking this because the shop floor personnel are mis-typing several words as they are inputting the information into a non-conformance database.
Mar 20 '07 #1
Share this Question
Share on Google+
3 Replies

P: 36
I use this code on any free type txt boxes that i have in my forms:
Expand|Select|Wrap|Line Numbers
  1. Private Sub txtnameoftextbox_AfterUpdate()
  2. 'If the textbox contains data run the
  3. 'Spell Checker after data is entered.
  4.     If Len(Me!txtnameoftextbox & "") > 0 Then
  5.         DoCmd.RunCommand acCmdSpelling
  6.             Else
  7.         Exit Sub
  8.     End If
  9. End Sub
Mar 20 '07 #2

Expert Mod 10K+
P: 14,534
That's a nice piece of code.

Mar 21 '07 #3

P: 78
that worked great thank you and the GM is pleased....No more reports with misspelled words!!! YAY to you!!
Mar 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.