Currency Format

[fvillena]

Hi Everyone

I have a field in an access database, which holds the ticket price in a field type of currency.

The values store in my database correctly but when I output the value onto an ASP page the decimal places are missing, so if I have a value of €7.50, €7.5 is displayed.

I've tried using FormatCurrency but to no avail.

Regards

Francisco Villena

[rdoekes]

the formatcurrency function has an optional argument NumberDigitsAfterDecimal:

Response.Write FormatCurrency(17.5, 2) becomes $17.50