Question Phone Number Changing by Itself

yajtheman

New member
Local time
Today, 10:16
Joined
Aug 14, 2013
Messages
2
I've run into a rather strange problem. In Access 2002, I have a Phone Number field (Text) that is meant to store (obviously enough) phone numbers. However, when I enter 2009 as the last four digits (ex. (555)-555-2009) the number is changed to (555)-555-2010. This also occurs if I enter the number directly into the table (which doesn't have an input mask). I have tested it in a new form (even without input mask), and a new table, which both result in the exact same thing. Any ideas?
 
Check proofing /auto-correct settings. I have no idea where those might be located in your version.
 
Yep that's it, Thanks! Strange though that it should replace 2009 with 2010 and 09 with 10. It seems to be default (or at least is there on two separate computers). Any idea why?
 

Users who are viewing this thread

Back
Top Bottom