Input Mask prob - Telephone pattern

S

Sam Kuo

I have a telephone field in my table. I'd like to restrict the pattern of
entry to be something like (0?)??? ????

So I have this in the Input Mask as suggested by F1 help:
"(0"0") "000\-0000;0;?

But this would only display the number as say 91234567 in View, rather than
(09)123 4567 as I intended - i.e. both Brackets ans Space aren't shown!

What would be the work around for this? Many thanks for your time and help
 
M

Mike Painter

Sam said:
I have a telephone field in my table. I'd like to restrict the
pattern of entry to be something like (0?)??? ????

So I have this in the Input Mask as suggested by F1 help:
"(0"0") "000\-0000;0;?

But this would only display the number as say 91234567 in View,
rather than (09)123 4567 as I intended - i.e. both Brackets ans Space
aren't shown!

What would be the work around for this? Many thanks for your time and
help
Click to expand...

I hate input masks and would suggest a @@@ @@@-@@@@ format instead.

This way a local number shows properly and you can still toss in an area
code.

If you do use the Input mask teach your users to click on the label instead
of inside the field. This will always put the cursor in the right spot.
 
S

Sam Kuo

thanks Mike. I will take on your suggestion because I find the Input Mask
somewhat annoying too. But the 1st digit of area code being 0 (in New
Zealand) still doesn't display in View. What can I do about it?? Thanks
 
S

Sam Kuo

Please igonre my last post. I noted that its just a matter of putting a slash
(\) before 0 to make it a literal character.
 
Top