Facing difficulty to work with your MS Access AutoCorrect option flawlessly? Or does your MS Access Autocorrect not working?
Don’t know how to fix Access AutoCorrect not working issue?
Not to worry, because in my today’s topic I will discuss Access AutoCorrect feature. So with the following article you can easily learn what setting preferences change you need to perform for fixing up this Access AutoCorrect not working issue.
What Is AutoCorrect Feature In Access?
Access offers two kinds of AutoCorrect options:
- Name AutoCorrect
AutoCorrect feature of Access is very useful for applying some specific or spelling or formatting for certain kind of phrases which you use very often.
MS Access gives close attention to how you type correction which ultimately makes your future typing easier.
The main purpose of this AutoCorrect feature is to change the misspelled words with the appropriate one. Like the same, you can also define some shortcodes to automatically replace it with long phrases or words.
2. Name AutoCorrect:
When multiple users frequently working in the Access database which is having a design in it. Meanwhile, database objects may be stopped working if any changes done in the database objects.
This situation mostly rendered when the object name is changed but those changes are not well accompanied by the original database object.
- This Access name AutoCorrect option track name changes and corrects the name of objects like forms, reports, tables, queries, fields or controls, etc.
- It helps to find when the database object name changing process hamper the performance of other database objects.
- Automatically fixes the issue.
- Keep a record of all the corrections it does.
Note: MS Access Name AutoCorrect works great in synchronizing the names of database objects.
Other database design problems like the deletion of any objects can’t be handled by this name AutoCorrect feature.
Why Is Your Access Autocorrect Stopped Working?
Here is the following reason that imparts to Access AutoCorrect not working situation.
- Maybe you are trying to track the changes done form, control name, or report. So let me tell you that it doesn’t track such things.
- It won’t correct Table, field, query names present in macros, or in the code.
Problems associated with Access AutoCorrect feature:
- Unable To Change Database Design:
If your database design won’t changes even after attempting so many efforts then turn off the name AutoCorrect option. This will improve system performance.
- Increases The Database Size:
When Access name AutoCorrect feature is enabled, database size gets increases. This happens because of the creation of name maps by the name AutoCorrect. If you disable this name AutoCorrect option, then name maps are also been removed which automatically reduces the database size.
How To Fix MS Access AutoCorrect Not Working Issue?
1. Turn Off and On AutoCorrect
If your MS Access AutoCorrect not working properly then Turn Off AutoCorrect.
You can turn off this AutoCorrect, by doing the following:
- Hit the File tab from your Access menu bar. After that from the File drop-down menu choose the Options.
- In the opened window of Access Options, tap to the Proofing option present on the left sidebar.
- From the Proofing option window make a tap on the button of AutoCorrect Options.
- Now from the opened window of AutoCorrect, you have to uncheck the “show AutoCorrect Options buttons”. After that tap to the OK button.
- Close your Access database completely and again reopen it.
- Now perform the step 1 to 3 and once you reached AutoCorrect option window, check the “show AutoCorrect Options buttons”.
- At last tap to the OK option.
2. Disable Or Enable Name AutoCorrect options
The second option is to disable or enable name AutoCorrect options in the current access database.
1. From the MS Access ribbon, tap to the File and then to Options. This will open the dialog box of Access options.
2. Tap to the current database option present on the left pane of Access Options
3. Within the options of Name AutoCorrect, select any of the following three options.
Name AutoCorrect contains three options: Track name AutoCorrect info, Perform name AutoCorrect, and Log name AutoCorrect changes.
Let’s know about each of these options in brief.
- Track name AutoCorrect info:
If you select this option, Access keep tracking of the database object name modifications occurring in your Current database.
All the tracked information is saved in the name maps. When this Track name AutoCorrect info option is turned ON Access creates an individual name map for all the existing objects of the database.
As long as this option is enabled, you will always get the updated name map. This name map helps greatly to resolve errors accused by the renaming of objects. With this you can take out information about the object dependencies of any database.
You can’t access the name map directly. Enabling this Track name AutoCorrect info option doesn’t correct previous mistakes of your database object name. Though this will create a name map that will help in your future correction.
- Perform name AutoCorrect:
Choosing this option will automatically fix object name changes whenever they happen. To use this option, it’s important that your Track name AutoCorrect info option is previously kept enabled.
As the Perform name AutoCorrect, it makes use of name maps created by the Track name AutoCorrect info option.
- Log name AutoCorrect changes:
MS Access keeps a log of all the corrections done by name AutoCorrect. Every individual correction seems like a record within this Name AutoCorrect Log table.
To use this option also, it’s important that your Track name AutoCorrect info option is previously kept enabled.
3. Restart The Interrupted Name Mapping Process:
Your Access AutoCorrect maybe not working because of interruption in the name mapping process.
So you need to restart the process of updating the name maps. Follow the steps to perform this:
- Tap to the File tab from the access application menu bar. Now from the File menu drop-down choose Options.
- This will open the Access Options dialog box.
- Tap to the Current Database option from the left pane of Access Options
- Uncheck the checkbox of Track name AutoCorrect info option and tap to the OK button.
- Access asks you to close all the opened database objects to let the changes happen.
- Close your Access database completely and again reopen it.
- Now perform the step 1 to 3 and once you reached current database option window, check the Track name AutoCorrect info option. At last tap to the OK option.
For manually updating the name map of any particular object just open the object in the design view and save your Access database object.
After reading the complete post, you must have got enough idea on how to fix MS Access Autocorrect not working problem. So try all the solutions I have listed above and do share your experiences with us.