• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 51
  • Last Modified:

MS Access Report Currency Format not Working As it Should

I have a form with a unbound text box called "txtTotalDue" that holds a Currency Value. Property sheet is set up with Format Currency and decimal Auto.

 I have a query and in this query I have a field called "TotalDue". It is set up like so:
TotalDue: [Forms]![frmCashPayment]![txtTotalDue]

Open in new window

This query field will not give me the format option to change it.

Finally I have a report that has a text box that has the query field "TotalDue" as it's control source.

On my Report it will not show it as currency no matter what I do and it also keeps showing a decimal out of whack. I have evn tried to change decimal point to "2" but no luck.

 I have tried Format currency in the property sheet and I have tried $#,###.00;-$#,###.00;$0.00 in the format box. I have tried several different ways but nothing seems to work.

It shows perfectly on my form but not in my query or my report

Thank you for the help.
0
Dustin Stanley
Asked:
Dustin Stanley
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Wrap your form reference with Ccur( )

Jim
0
 
Dustin StanleyEntrepreneurAuthor Commented:
Well Jim I'll be a monkey's uncle! That worked perfectly! Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now