Hi to any Access gurus. Any d/bases I have created I use TEXT for fields containing phone numbers cos there is 10 digit length max for Long integer (if field is set as number rather than text). That is, a typical mobile num is 11 digits long. How can I use a proper datatype ( number rather than text ) for such fields to let me enter 11 digits ? Ta in advance for all responses.
I am generally in agreement with fourm member and imacd in that it is normal to use text fields for telephone numbers as you can then use the input mask. However you can retain the 0 at the beginning of an area code if you specify it in the format property ie 0####.