How do people deal with this seemingly common issue, considering our global economy, using only one textbox?

Can't format or input mask for both types of phone numbers.

Am I looking at invisible textboxes again?

Somehow reinventing the wheel doesn't seem necessary.

thx, bph

If a US and Canadian number has ten digits and other international phone numbers have more then store JUST the number in the table WITHOUT the formatting (it saves space, btw). However, on the form and reports' On Current events, format the textboxes on the fly to fit the number based on the country.

In other words, STORE just numbers but SHOW proper formats based on country.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and then click on Tejpal, A.D. He has a sample database called InputMask_Dynamic.mdb with the following description:
This sample db demonstrates dynamic setting of Input Masks at run time - with
partly pre-filled values as desired.
Three cases are covered -
        (a) Phone Numbers - with area codes pre-filled
        (b) Dates pre-filled with desired month and year part.
        (c) Text string prefixed/suffixed with current month-year.
The sample is in Access 2000 file format developed on Access XP installation.

HTH,

Beth M

Thanks to you both. Plenty of good info to work with.

Okay, so I thought I had come up with a simple way to solve this issue. And I think I'm on the right track.
I created a unbound checkbox called chk_USA on the form next to the phone number text box.
In the ONCURRENT Event if have the ollowing code.

If Me.Chk_USA.Value = True Then
Me.txtContactPerson_Phone_Number_1.InputMask = "999\-000\-0000;0;_"
Else: Me.txtContactPerson_Phone_Number_1.InputMask = "#########################"

My theory is that if the box is checked then "999\....format for entry in the txtbox. Else enter whatever the foreign number is. Somehow the code doesn't pick up the checked box and give me the "999\...format. Always get the else format__________________ ? What am I missing -- thx, bph

Change that to just

If Me.Chk_USA Then

Because Me.Chk_USA is a checkbox that holds a boolean value (True/False), you don't need to quantify it for the IF statement.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I put the code in the control on the form and it's working.

This format {InputMask = "999\-000\-0000;0;_"} allows for the entry of a typical phone number, say 456-123-7890. What needs to be added to the mask to allow for an extension to be typed into the same field right after the phone number?

Thanks....bph