Discussion of Forex Trading and Currency Trading

Access 2007 Report not showing currency when all seems to be formatted properly?

I have created a report in Access that needs to show currency amounts. I have my field in my table set to currency and the report pulls off a query that also shows the currency properly. However, when I generate the report it only shows it in a number. I have formatted to currency and tried every trick I know. What am I missing?

Most Commented Posts

 

 

One Response to “Access 2007 Report not showing currency when all seems to be formatted properly?”

  1. Hello Stacks52… ,

    I’m not totally familiar with Forms in access, although how about if you click in the number field on your form and choose properties, the change the format to currency.

    Hope this helps,
    dtcom

Leave a Reply