Negative Number - Brackets instead of negative signs - AOS168b AT comcast DOT net

Hi John,

Try this article:

Conditional Formatting In Forms And Reports
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Negative Number - Brackets instead of negative signs - Rick Brandt

The format property for numbers can be divided into four sections separated
by semi-colons.  Each section respectively controls the format for...

Positive values
Negative values
Zero
Null

Example:


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Negative Number - Brackets instead of negative signs - J. Trucking

Hello,

I just had a quick question.  I have set up an invoice db but in my
calculations, when the result is negative, the result has a negative
sign in front of the number.  I would like to show brackets instead.
Does anyone know how to format things this way.

Thanks in advance,

John

Negative Number - Brackets instead of negative signs - J. Trucking

Thanks fir the help Rick and Tom.  I'll give it a try.