Microsoft access spell check vba

You should upgrade or use an alternative browser. Thread starter Rabbitoh Start date Jun 25, Rabbitoh Registered User. Local time Tomorrow, Joined Jul 17, Messages I want to run a spell check on the contents entered by a user into a field on an active Form. This can be either automatic as user types or manually activated via a button on the Form itself.

Can this be done and if so, what code would allow this to take place. Last edited by a moderator: Nov 14, Rich Guest. RunCommand acCmdSpelling. Rich said:. Local time Today, Joined Feb 12, Messages Open the form for editing, right click on the field you wish to spell check - go to properties - then to the "Event" tab.

Click the box with three dots inside that appears to the right. The VB Editor will appear. Use the below code: Code: Copy to clipboard. SetWarnings False DoCmd. SetWarnings True End Sub. My Form does not show an event tab. Tried the code without but could not get to work. Thanks anyway. For the benefit of others, I did it this way thanks to Andy Pope. Text Range "A1". CheckSpelling then unloaded the Form and reloaded it again with the updated cell content text now corrected by the Excel Spellchecker.

Local time Today, Joined Jan 12, Messages 32, When filling in information in your Microsoft Access forms, you may wish to ensure that your users are correctly spelling words, particularly if this data is going to be viewed by other users. There are a few ways that you can check your spelling when entering data into an Access form, but you may wish to ensure that this is done automatically, to make sure that your users don't forget!

There, place the VBA code that will call the spell checking routine. When a spelling error happens, it is detected automatically when the user finishes entering text. The VBA code is invoked and the spell checking dialog comes up. Here is how you can create a spell checker feature using ms-access with some simple VBA commands. But the problem remains that it would still only check for that one record.

I proposed to the client checking the spelling of that one field as it's edited. He said that's fine, except that the spell checker comes up EVERY time, even if there are no spelling mistakes. He doesn't like that. So I'm left with two options: 1 find a way to run the spell checker for all records in the form, but only for a particular field in each record; or 2 find a way to have the spell checker pop up after that particular field is edited, but only if there's a spelling error.

I guess there's a third option: find a third-party spell checker that provides more programmatic control. Neil wrote: "Thanks, Arvin. Have you tried it out? I just saw your post.

Since my original message was cross-posted, but you only responded in this newsgroup, I didn't see your message because I was looking in another newsgroup. So, yes, your solution would work.

Thanks for that. This discussion thread is closed Start new discussion. Similar topics Java.