negative value

Hi, I have prompt in the report
of the text field "Enter Credit Amount".  User will enter value of 500

I need to display in the report this value in the following way ($500.00).  How can I do this
maximyshkaAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Put a minus sign in front of the Prompt ... see image.

mx
Capture1.gif
0
 
maximyshkaAuthor Commented:
This value should be listed in the report as negative.  User will enter only amount
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Use the Format property as shown below

mx
Capture1.gif
0
 
maximyshkaAuthor Commented:
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.

All Courses

From novice to tech pro — start learning today.