March 9, 200718 yr I'm sure this has already been covered numerous times, but I just can't seem to figure out what I'm doing wrong. When defining a client database, one of the fields I have is phone numbers. I defined the field as a "Number" type. When I type in a 10-digit phone number in this format "8883334444" it automatically changes into "8.8833e+09". I don't want it to display in this form. What am I doing wrong? Thank you and I apologize if this has been covered already. I did a search but I couldn't find anything related to my problem.
March 9, 200718 yr As strange as it may sound, a phone number is actually text, and the field type should be set accordingly.
Create an account or sign in to comment