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

 

[Tom Wickerath]

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
__________________________________________

 

[Rick Brandt]

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

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:
#;\[#\];"Zero";"Null"

 

[J. Trucking]

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