International elephone number format

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In access2000, i have a packing slip that has a telphone number field. I
was asked to change the field to accept international numbers. HELP
 
First to preserve your current formatting, I would change
toe format to save the data with the formatting, than
replace all phone numbers with the current phone number so
as to save all numbers with the formatting.
Than of course one could assign a conditional format based
on the country, however what I found easiest is change the
field to a text item without formatting, and just enter
the desired dashes or parenthesis as applicable.
Hope this helps.
Fons
 
I would be inclined to add another table to your database with the names of
the countries and their dialling codes. Put a linking field for them to your
phonenumber table. Then you can add them with a combo box.

In the query behind your report combine the phone number with the dialling
code in a field

WholePhone: DialCode & PhoneNum

or if they want a space between them

DialCode & " " & PhoneNum

Replace your phone number field in the report with this new field.

Evi
 
Back
Top