How do you make the amount in a currency text box appear red if its negative? Right now it shows in parenthesis but I would like it to be red as well. Is this possible? It's also a calculated text box if that makes a difference.
How do you make the amount in a currency text box appear red if its negative? Right now it shows in parenthesis but I would like it to be red as well. Is this possible? It's also a calculated text box if that makes a difference.
Is this on a Report or Form?
Perhaps try using Conditional Formatting.
this is on a form. how would i go about using conditional formatting?
See: http://stackoverflow.com/questions/1...ms-access-form
There are also some of links on YouTube, if you would like to see some tutorials.
I figured it out. Thanks for much for the suggestions.