Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formatting output in the report

Status
Not open for further replies.

cancer2006

Programmer
Aug 25, 2006
45
US
I want to adjust the formatting of the telephone number. as
"123-456-7890" right now it is displaying as 1234567890.

I am using Access97. my database field name is "Best time to call" data type text.

How do I change the formatting? Do I need to write a VB code or go into expression builder.

Thanks.
 
You should be able to go into the field's properties and click on "input mask". There is a wizard to walk you through some of the steps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top