Display in red when negagive, black in zero or positive

[Song Su]

I have a calculated control on the form. I want it to be in Red color when
it's negative, otherwise, in Black color.

Thanks.

 

[Rick Brandt]

I have a calculated control on the form. I want it to be in Red color
when it's negative, otherwise, in Black color.

Thanks.

The format property for controls displaying numbers can consist of four
sections separated by semi-colons. They respectively set the formatting for
positive numbers, negative numbers, zero values and Null values.

In your case try something like...

0[Black];0[Red];0[Black]

 

[Song Su]

still don't understand. can you provide steps as to how to do it? Thanks.

- Song

I have a calculated control on the form. I want it to be in Red color
when it's negative, otherwise, in Black color.

Thanks.

The format property for controls displaying numbers can consist of four
sections separated by semi-colons. They respectively set the formatting
for positive numbers, negative numbers, zero values and Null values.

In your case try something like...

0[Black];0[Red];0[Black]

 

[Douglas J. Steele]

Step 1: Find the Format property on the Properties sheet for the textbox.
Step 2: Set the Format property to something like 0[Black];0[Red];0[Black]

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

still don't understand. can you provide steps as to how to do it? Thanks.

- Song

In your case try something like...

0[Black];0[Red];0[Black]

I have a calculated control on the form. I want it to be in Red color
when it's negative, otherwise, in Black color.

Thanks.

The format property for controls displaying numbers can consist of four
sections separated by semi-colons. They respectively set the formatting
for positive numbers, negative numbers, zero values and Null values.

 

[Song Su]

Got it. Thanks.

Step 1: Find the Format property on the Properties sheet for the textbox.
Step 2: Set the Format property to something like 0[Black];0[Red];0[Black]

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

still don't understand. can you provide steps as to how to do it? Thanks.

- Song

In your case try something like...

0[Black];0[Red];0[Black]

Song Su wrote:
I have a calculated control on the form. I want it to be in Red color
when it's negative, otherwise, in Black color.

Thanks.

The format property for controls displaying numbers can consist of four
sections separated by semi-colons. They respectively set the formatting
for positive numbers, negative numbers, zero values and Null values.