Telephone Format

[DS]

I'm storing telephone numbers as text.
I want to display that telephone number on an unbound form in an unbound
textbox.
So in the format of the textbox I put (000) 000-0000
However it's not formatting.
Any suggestions welcomed.
Thanks
DS

 

[Ken Warthen]

DS,

Use an Input Mask instead of format. Open your form in design view. Click
on the control in question. Open the properties sheet to the Data tab. Just
below Text Format is Input Mask. Click on the ellipsis button and you'll see
how to set up the input mask for a telephone number.

Ken Warthen

 

[Marshall Barton]

I'm storing telephone numbers as text.
I want to display that telephone number on an unbound form in an unbound
textbox.
So in the format of the textbox I put (000) 000-0000
However it's not formatting.

Text fields can not be formatted using number format codes.

As long as the field only contains digits, you can use:
(@@@) @@@-@@@@

If the field might contain space, parens and/or dashes, then
use the Replace function to remove them.

 

[DS]

Works reat.
Thanks
DS

 

[DS]

Thanks Marshall.
DS