I have an Access table that have phone numbers stored in it.
I am using an input mask that looks like this 999 999 9999 when entering the
data, but I am sure that Access is storing the data like this 9999999999.

My problem is when displaying the number in FrontPage it is displayed like
this
9999999999 how can I make the number show like this 999 999 9999 in FrontPage.


Thanks Bill

http://www.spiderwebwoman.com/resour...icks.asp#phone

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others






"Bill Winter" <(E-Mail Removed)> wrote in message
news:36052F20-CD24-4302-B213-(E-Mail Removed)...
>I have an Access table that have phone numbers stored in it.
> I am using an input mask that looks like this 999 999 9999 when entering
> the
> data, but I am sure that Access is storing the data like this 9999999999.
>
> My problem is when displaying the number in FrontPage it is displayed like
> this
> 9999999999 how can I make the number show like this 999 999 9999 in
> FrontPage.
>
>
> Thanks Bill

When you create the input mask, there is an option for saving data with the
formating or without the formating. Chose the one that saves the formatting.
Access will then save the spaces, dashes, parenthesis, and other formating
stuff in the table and therefore on your FP Pages.

"Kathleen Anderson" wrote:

> http://www.spiderwebwoman.com/resour...icks.asp#phone
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
>
>
>
>
> "Bill Winter" <(E-Mail Removed)> wrote in message
> news:36052F20-CD24-4302-B213-(E-Mail Removed)...
> >I have an Access table that have phone numbers stored in it.
> > I am using an input mask that looks like this 999 999 9999 when entering
> > the
> > data, but I am sure that Access is storing the data like this 9999999999.
> >
> > My problem is when displaying the number in FrontPage it is displayed like
> > this
> > 9999999999 how can I make the number show like this 999 999 9999 in
> > FrontPage.
> >
> >
> > Thanks Bill
>
>
>

Thank you for the respones, I tried your tip but for some reason it did not
work.

"OC Del Guy" wrote:

> When you create the input mask, there is an option for saving data with the
> formating or without the formating. Chose the one that saves the formatting.
> Access will then save the spaces, dashes, parenthesis, and other formating
> stuff in the table and therefore on your FP Pages.
>
> "Kathleen Anderson" wrote:
>
> > http://www.spiderwebwoman.com/resour...icks.asp#phone
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> > FrontPage Resources: http://www.spiderwebwoman.com/resources/
> > Please reply to the newsgroup for the benefit of others
> >
> >
> >
> >
> >
> >
> > "Bill Winter" <(E-Mail Removed)> wrote in message
> > news:36052F20-CD24-4302-B213-(E-Mail Removed)...
> > >I have an Access table that have phone numbers stored in it.
> > > I am using an input mask that looks like this 999 999 9999 when entering
> > > the
> > > data, but I am sure that Access is storing the data like this 9999999999.
> > >
> > > My problem is when displaying the number in FrontPage it is displayed like
> > > this
> > > 9999999999 how can I make the number show like this 999 999 9999 in
> > > FrontPage.
> > >
> > >
> > > Thanks Bill
> >
> >
> >

Kathleen, thanks for your help I gave it a try but no luck. this is what I
have.

Thanks for your help

SELECT People.tFirstName, People.tLastName, Company.tCompanyName,
Company.tAddress1, Company.tAddress2, Company.tCity, Company.tState,
Company.tZipCode, People.tEmailAddress, Company.Active, Company.tType,
Company.twebsite, People.tMobilePhone, Company.tPhone1, Company.tPhone,
People.Phone,
FORMAT(tPhone,'(###) ###-####') AS NewPhone
FROM People INNER JOIN Company ON People.iCompanyFk=Company.iCompanyPk
WHERE (((Company.Active)=True) AND ((Company.tType)="Allied"))
ORDER BY Company.tCompanyName;

"Kathleen Anderson" wrote:

> http://www.spiderwebwoman.com/resour...icks.asp#phone
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
>
>
>
>
> "Bill Winter" <(E-Mail Removed)> wrote in message
> news:36052F20-CD24-4302-B213-(E-Mail Removed)...
> >I have an Access table that have phone numbers stored in it.
> > I am using an input mask that looks like this 999 999 9999 when entering
> > the
> > data, but I am sure that Access is storing the data like this 9999999999.
> >
> > My problem is when displaying the number in FrontPage it is displayed like
> > this
> > 9999999999 how can I make the number show like this 999 999 9999 in
> > FrontPage.
> >
> >
> > Thanks Bill
>
>
>

FORMAT(tPhone,'(###) ###-####')
should be
FORMAT(Company.tPhone,'(###) ###-####')

This will only format the Company.tPhone field. You will have to repeat
this for all the other telephone numbers if you want them formatted as
well. You can remove Company.tPhone from the SQL since you will be
displaying the NewPhone field instead.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"Bill Winter" <(E-Mail Removed)> wrote in message
news:F309B4C5-7FCD-406D-A4FF-(E-Mail Removed):

> Kathleen, thanks for your help I gave it a try but no luck. this is what I
> have.
>
> Thanks for your help
>
> SELECT People.tFirstName, People.tLastName, Company.tCompanyName,
> Company.tAddress1, Company.tAddress2, Company.tCity, Company.tState,
> Company.tZipCode, People.tEmailAddress, Company.Active, Company.tType,
> Company.twebsite, People.tMobilePhone, Company.tPhone1, Company.tPhone,
> People.Phone,
> FORMAT(tPhone,'(###) ###-####') AS NewPhone
> FROM People INNER JOIN Company ON People.iCompanyFk=Company.iCompanyPk
> WHERE (((Company.Active)=True) AND ((Company.tType)="Allied"))
> ORDER BY Company.tCompanyName;
>
> "Kathleen Anderson" wrote:
>
> > http://www.spiderwebwoman.com/resour...icks.asp#phone
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> > FrontPage Resources: http://www.spiderwebwoman.com/resources/
> > Please reply to the newsgroup for the benefit of others
> >
> >
> >
> >
> >
> >
> > "Bill Winter" <(E-Mail Removed)> wrote in message
> > news:36052F20-CD24-4302-B213-(E-Mail Removed)...
> > >I have an Access table that have phone numbers stored in it.
> > > I am using an input mask that looks like this 999 999 9999 when entering
> > > the
> > > data, but I am sure that Access is storing the data like this 9999999999.
> > >
> > > My problem is when displaying the number in FrontPage it is displayed like
> > > this
> > > 9999999999 how can I make the number show like this 999 999 9999 in
> > > FrontPage.
> > >
> > >
> > > Thanks Bill
> >
> >
> >