Products Results Page Formatting

[Jim]

Hello,
I'm using Access 2003 with FrontPage 2003. Does anyone know how to format a
phone number field in a database results page so it shows up as (123)
456-7890, instead of 1234567890? And is it possible to insert a carriage
return after every comma in a field, so I can get a list that reads:

Product 1
Product 2
Product 3

Instead of Product 1, Product 2, Product 3?
Thanks

Jim

 

[Kathleen Anderson [MVP - FrontPage]]

Hello,
I'm using Access 2003 with FrontPage 2003. Does anyone know how to
format a phone number field in a database results page so it shows up
as (123) 456-7890, instead of 1234567890?

How to format a Database field as a Telephone Number?

In your SQL, you could do this:

FORMAT(WorkPhone,'(###) ###-####') as newPhone

newPhone will show up on your page.


--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/



And is it possible to