input mask

[seeker]

I have a phone textbox that I want to have the input mask be: 000\-0000"
(316)";0;0. I want it to appear as 000-0000 (316) and allow the user to
change the 316 if they choose. the above input mask lets me fill in the 0
placeholder but not the 316. Also when my form opens i would like the phone
textbox to be filled in with 000-000 (316) which i have put into the default
value as "000-0000 (316) but what shows when the form opens is 000-000/
(316). The slash does not need to show. Thank you.

 

[Clifford Bass via AccessMonster.com]

Hi,

And what happens when someone needs to enter a foreign telephone number
that does not follow that format? Or what happens when someone needs to
enter an extension? My preference is to use a simple text box where the user
can enter the number in any fashion that is necessary. They are then stored
as 25-30 character text fields.

So, if you still need to use that format, how are you storing the
telephone number? Text (how long)? Number (what type)?

Clifford Bass

 

[seeker]

This type of format is a business requirement of my client. I would do
things much differently but this forum has not enough room for that
discussion. I need to know an answer to the question. I will be storing the
data as text.15 characters.

 

[Gina Whipp]

seeker,

Try changing your Input Mask and Default Value (with quotation marks) to the
below...

Input Mask: 000\-0000" ("000\);;
Default Value: "000-000 (316)"

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Clifford Bass via AccessMonster.com]

Hi,

I hope you or someone else has explained the flaws of that requirement.
Regardless, try this, which is close to what Gina suggested:

Mask: 000\-0000" ("000\);0;" "
Default Value: "000-0000 (316)"

If you set Access's "Behavior [on] entering field" property to "Go to
start of field", it works pretty nicely.

Clifford Bass