phone number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I simply want to know when entering data into Access, in the phone field- is
typing in dashes between area code, prefix and the last four numbers going to
mess up the data appearance when printing up documents that include the phone
number?
 
SACO said:
Hi!

I simply want to know when entering data into Access, in the phone
field- is typing in dashes between area code, prefix and the last
four numbers going to mess up the data appearance when printing up
documents that include the phone number?
Click to expand...

You want uniform data saved. I suggest you force a format on the entry
form. Do not use a table to enter data. In any case consider an input mask

From the help file:
The following table shows some useful input mask definitions and examples of
values you can enter into them.
Input mask definitionExamples of values
(000) 000-0000 (206) 555-0248
(999) 999-9999! (206) 555-0248
( ) 555-0248
(000) AAA-AAAA(206) 555-TELE
#999-20
2000
L????L?000L0GREENGR339M3 MAY R 452B7
L0L 0L0T2F 8M4 00000-999998115-
98115-3007
L<??????????????Maria
Click to expand...
Pierre
ISBN 0-&&&&&&&&&-0ISBN 1-55615-507-7
ISBN 0-13-964262-5
LL00000-0000DB51392-0493
Click to expand...

Sorry about the formatting, Open up the help file and look for phone
formatting.
 
Back
Top