|
-
Nov 16th, 1999, 01:40 AM
#2
Add two string fields to the table that contains the country. Store the format string for the phone number in one (in this example I've named it fsPhoneNumber) and the format string for the postal code in the other. (BTW the format string for the phone number is (###)###-#### but I don't know how to easily add the space needed in the postal code format string.) When you know the country use the database format string in the format expression like MsgBox Format(MyPhoneNumber, fsPhoneNumber).
------------------
Marty
[This message has been edited by MartinLiss (edited 11-16-1999).]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|