Because form field text is formatted as No Proofing, the spelling and grammar checker ignores text in form fields. if your Microsoft Word does not detect spelling and grammar mistakes, check theLanguage settings. Type in the field, it cause the program to crash. The spelling and grammar checker in Microsoft Word doesn't check text in the form fields. In my testing I found that when you hit Enter several time when you.I'm guessing that Access is crashing because more than one correction trigger the event again and since spell Check is already running the program crash. Also, I would like to limit spell check to one field and force it after the user exit the field. I hide the ribbon to prevent the users from messing around so this option is not going to work.
The only way I can run spell check is using the spell check on the ribbon. Launched from the FileAdd-Ins menu, Total Access Spellers Spell Check Wizard guides you through the selection of the table (or query) and text and memo fields to spell check.
I also decompile the database and found no erros. Simply enter your text into the form above, then hover over the Check Spelling button and select the language. After upgrading to O365 (Access 2016), the spell check works with no problems unless theres multiple spelling corrections.
I tried to change the code to run On Exit event but it didn't help. If the user choose to Change All or change more than 1 word Access crash and the user need to restart the program. If IsNull(Len(strSpell)) Or Len(strSpell) = 0 ThenĪfter upgrading to O365 (Access 2016), the spell check works with no problems unless there's multiple spelling corrections.