When entering data one can occasionally misspell a word or two.
We are all used to having a spell checker at hand when typing a Word document for instance.
There is nothing worse than spending hours typing a document in an office environment, only for your boss to pull you up over your spelling mistakes.
Even worse, imagine sending out a badly spelt letter to a customer.
It's just not the correct way to do business.
Some people think bad spelling does not matter so much as long as the main points of the document are conveyed to the reader.
Sadly, this is not the way to go and is considered extremely bad practice.
Why should a spell check be limited to Word documents? Surely it would be of benefit if we could incorporate something similar in an Access database.
Well, I have some good news.
We can do exactly that! Create a form with a text box or memo field.
Enter some text into either of these controls.
Create a command button on your form.
Go into the properties of the button and set the caption to be 'Spell Check'.
Right click the command button and select 'Build event'.
Between the Private Sub and the End Sub enter the following code You can copy and paste it if you like With Me![My control name] If Len(.
Value) > 0 Then DoCmd.
SetWarnings False.
SetFocus.
SelStart = 1.
SelLength = Len(.
Value) DoCmd.
RunCommand acCmdSpelling.
SelLength = 0 DoCmd.
SetWarnings True End If End With Replace the words inside the square brackets [My control name] with the name of your own control that you want to spell check.
Save the code and close the code window.
Now run your form and click the button.
Enter some misspelled text in your control and then click the spell check button.
You will find you get a similar spelling suggestion box that you have seen many times before when writing Word documents.
Don't worry too much about understanding it - I will cover Access programming in further tutorials.
This will give you a general idea though.
Summary Spell checking within an Access database is great to have.
We all make mistakes when typing and in some systems the integrity of information is vital.
If you were to search for example on the name 'James' and in fact what you wanted was 'Jones' then the results you get back would not be correct.
Make sure data is entered correctly and all words are spelt to your liking.
Thank you for reading