You might be missing typos in Access tables 

If you've ever found typos in a table that you're positive you remember spell checking, chances are that the typos are in words that Access purposely skipped during the spell check. By default, Access ignores words that are all upper-case or that have numbers in them. In most cases, this is probably fine. However, especially with purchased data, you'll occasionally come across tables where everything is capitalized. Fortunately, you can change the way Access spell checks so that all words are included. To do so, run the spell checker on a data selection that will cause the Spelling dialog box to be displayed. Then, click the Options button and clear the Words In UPPERCASE and Words With Numbers check boxes. Finally, click OK and then Cancel.

Access Index

Main Index