Formatting currency in a FrontPage Results page

[Guest]

I"m pulling price info from a database. The price field in the database is
formatted as currency but the results page it is not showing as currency. I
tried changing the field to a text field but then it doesn't sort correctly.
How do I format the resulting field as currency ie $1,300,995 ?

 

[Stefan B Rusynko]

See http://www.devguru.com/technologies/vbscript/quickref/formatcurrency.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I"m pulling price info from a database. The price field in the database is
| formatted as currency but the results page it is not showing as currency. I
| tried changing the field to a text field but then it doesn't sort correctly.
| How do I format the resulting field as currency ie $1,300,995 ?
| --
| Hopeful Thanks
| Meemers

 

[Guest]

Thank you - but the item I am trying to format as currency is the value of a
field from a database - how do I get that into the expression? It's a webbot.

 

[Kathleen Anderson]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--

~ 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

Thank you - but the item I am trying to format as currency is the value of
a
field from a database - how do I get that into the expression? It's a
webbot.
--
Hopeful Thanks
Meemers

See
http://www.devguru.com/technologies/vbscript/quickref/formatcurrency.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I"m pulling price info from a database. The price field in the database
is
| formatted as currency but the results page it is not showing as
currency. I
| tried changing the field to a text field but then it doesn't sort
correctly.
| How do I format the resulting field as currency ie $1,300,995 ?
| --
| Hopeful Thanks
| Meemers