need help with formatting field as currency with no decimal places (1 Viewer)

I have a calculated field in a query that generates a result that i need to display in forms/reports with the $ sign but zero decimal places (ie; rounded to the nearest $ value, $5).
If i use the sql format currency function (format (n, "currency",0) it always displays the $ sign but with two decimal places...
In the form/report text box property i set the format to currency, with the decimal places set to 0, but it still displays two decimal places (this property setting seems to make no difference other than displaying the $ sign). Is there something i am missing regarding the way access formatting works?

Try using the FormatCurrency function instead of the normal format function.

FormatCurrency([cost]*[items],0) will give you just the dollars

Thanks that works great!