How can I get numbers to be displayed as currency?

[ottagolater]

When I set up a table with numbers shown as currency it is displayed as single numbers on the .asp page.

EXP: $45.00 shown as 45 and $45.95 shown as 45.95.
It seems the the html will not carry over the number format that was in Access file.

There is a font format in the html but is there a number format in the html?

 

[TechnicalAnalysis]

Why don't you use the FormatCurrency function. Please check here for function specific.

http://www.4guysfromrolla.com/webtech/code/FormatCurrency.shtml