Negative_(#)_with Brackets (1 Viewer)

access2010

Registered User.
Local time
Today, 06:59
Joined
Dec 26, 2009
Messages
1,019
Can I please receive a suggestion on how to have a Negative General Number appear with opening and closing brackets?

Such as (125).

===
What code should I use to have Conditional Formatting of a Negative Number appear in pink?

===
The above requests are for use in a Ms Access 2003 Database.

Thank you.
Nicole
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 00:59
Joined
Jan 20, 2009
Messages
12,849
In the Format property of the control.
Code:
;(#)[Red]
 

June7

AWF VIP
Local time
Today, 05:59
Joined
Mar 9, 2014
Messages
5,425
Okay, but if there are any positive numbers (or zero) in the field, they won't show.
 
Last edited:

access2010

Registered User.
Local time
Today, 06:59
Joined
Dec 26, 2009
Messages
1,019
P E R F E C T

Can we have the $ dollar sign used within your brackets for the negative monetary values?

Paul
 

isladogs

MVP / VIP
Local time
Today, 13:59
Joined
Jan 14, 2017
Messages
18,186
Yes you can

See if you can modify this yourself to include the $ signs
Code:
#;(#)[Red];0

Its fairly obvious & should take you less time to work out than it did to post the question...and you will learn far more
 

access2010

Registered User.
Local time
Today, 06:59
Joined
Dec 26, 2009
Messages
1,019
Thank you for your assistance.
If we use your suggested code
= ;(#)[Red] = for a negative quantity it appears as = (107) = in Red Text
= ;(#)[Red] = for a positive quantity it appears = BLANK (no text)

= ;($#)[Red] = for a negative dollar amount it appears as = ($138.45) in Red Text
= ;($#)[Red] = for a positive dollar amount it appears as = BLANK (no text)

Could you please advise us how to correct the invisible problem?

Thank you,
Nicole
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 00:59
Joined
Jan 20, 2009
Messages
12,849
Code:
$#;($#)[Red];0

The format string is in four parts separated by semicolons.
The parts are the formats for positive, negative, zero, Null

If a part is omitted it won't display.

If you want thousand separators:
Code:
$#,###;($#,###)[Red];0
 

access2010

Registered User.
Local time
Today, 06:59
Joined
Dec 26, 2009
Messages
1,019
P E R FR E C T

Thank you for your assistance, I/We appreciate your help.

Paul
 

Users who are viewing this thread

Top Bottom