Solution to lowercase i problem with SetFocus

  • Thread starter Thread starter Brendan
  • Start date Start date
B

Brendan

If you have a text box into which you enter some text and
use the On Change function to SetFocus away from the text
box you will often get an error if you type in a lower
case i. The solution is to turn off the autocorrect
attribute for the textbox.

The problem happens when you type in a lowercase "i".
Access trys to autocorrect it to an "I" while at the same
time the "On Change" function is running, trying to
SetFocus away from the text field. Thus a runtime error
is formed.

Hope that helps somebody,

Brendan
 
I believe that Access uses the Autocorrect from Word. Go to Tools,
AutoCorrect (may have a slightly different name according to your version of
Word), type 'i' into the Replace box to bring up the entry which replaces i
with I and delete that entry. Other candidates for unticking is the
Capitalise first letter of sentence. I don't find either of these helpful in
Word and prefer to decide myself - a spell and grammer check will still pick
them up giving me the chance to rectify unintentional errors.
Evi
 
Back
Top