microsoft.public.frontpage.programming

Kathleen Anderson [MVP - FP]

4/22/2004 5:02:00 PM

Jim <res1i31k@verizon.net> wrote:
> 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/...



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