i auto changes to I in text field

[pas123]

Hi,

I need the text in the field to allow both lower and upper case but when the user enters "i" (only 1) it changes to "I" , "ii" works just fine.
How can I stop this??

I guess I could write an event code like:

Dim LowerCase, UpperCase
UpperCase = Me![FieldName]
LowerCase = LCase(UpperCase)
If Me.[FieldName].Value = "i" Then
Me![FieldName].Value = LowerCase
Else...

Any other ideas????

Thanks
Paul

 

[pas123]

I found that if I change the autocorrect by removing the i to I entry it is fixed. But I wonder if I would have to change this on all computers or if it would change just by running the database?

Thanks again