Field Format Question

I have a subform that has some calculated fields on it.  I would like to display negative values in red font and show them in paranthesis.  How can I do this?  I know I can change the font color using conditional formatting, but how best to accomplish the paranthiesis.

Instead of -400 I would like (400) in red.

Thanks!

we are a mixed environment on Office 2000 & 2007
snyperjAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
You can use the Format property of the text box ... see image:

mx
Capture1.gif
0
 
snyperjAuthor Commented:
I hate when I do that... (ask a question instead of using Help...)


Thanks.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Hey .... this is .. Help :-)

mx
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.