How can I display negative numbers in RED instead of black (forms)

[judy777]

Hi,

I would like to display negative numbers in RED instead of black on my forms. That way they stand out more clearly. Is there any way to accomplish this?

I am using MS Access 97.

Thanks,

Greetings from Amsterdam!
Judy

 

[jebry]

Hi!

Access supports conditional formatting. Select the text box you want to change and choose Format/Conditional Formatting and in the window that pops up give the condition as less than zero and the formatting will be to change the font color to red.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[corner40]

You'll have to use an If statement to set the color.
I'm no VB pro but it basically will be like this:

If txtNum < 0 Then
txtNum.ForeColor =&quot;255&quot;
End If

something to that effect anyways. That should get you started until someone posts the 100% correct answer.
hope that helps a little.

 

[Maquis]

Check out the help file entry for the Format command, Number data types. You can use the format property to specify that negative numbers be red.

I don't know the correct syntax or I would post it here. The help file should point you in the right direction though. Maq
<insert witty signature here>

 

[shannonp]

Simplest way would be to use the 'Format' property of the text boxes you want to make negative numbers red:

#,##0;[Red]#,##0

PS. This is a standard formatting rule

 

[Fubear]

Will this work in datasheet view as well?

 

[shannonp]

Unfortunately - I don't think it will.