Format Telepone Number

[shearness]

I am using a stored procedure to query data in a SQL backend. I have
the telephone number stored as 9999999999. I am wondering how I can get
that number formatted and displayed in a list box. I want standard
formatting, (999) 999-9999. How can I do this? Thanks.

 

[Sal Rosario]

Assuming a field named "phone", I'd do this:
"(" & Left([phone],3) & ") " & Mid([phone],4,3) & "-" & Right([phone],4)

Sal
www.cedrostec.com

 

[JL]

A list box is just a query. If you modified your query,
change the telephone number entry using

format([telephone number], "(000) 000-0000")

Hope this will help.

 

[shearness]

Thank you very much. That's got it.