Access Tip of the Day
Disable AutoCorrect for a single control (Access 97/2000/2002)
Most of the time, you probably welcome the AutoCorrect feature that's built into the Office suite of applications. AutoCorrect cleans up common typos automatically, speeding data entry and catching errors that might otherwise go undetected. Unfortunately, there are instances when AutoCorrect is inappropriate. For example, let's say that a table field stores codes. If you enter the code IDAE, AutoCorrect changes the entry to IDEA.
To turn the feature off completely, choose Tools | AutoCorrect from the menu bar, clear the Replace Text As You Type check box and click OK. However, if you'd only like to disable the feature for a particular form control, you can do so. Simply change the control's Allow AutoCorrect property to No (if you're using VBA, set AllowAutoCorrect to False). Unfortunately, you can't set this property at the table design level.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.