changing colors of numeric fields

[jhickers]

In MS 2003 or 2002 can anyone tell me the simplist way to change color
of text in a form or report? I want the values of currency fields
changed to red if the amount is >= to $1,000. I am not a programmer!
Thanks

[fredg]

On 18 Jan 2005 16:17:54 -0800, jhickers wrote:

In MS 2003 or 2002 can anyone tell me the simplist way to change color
of text in a form or report? I want the values of currency fields
changed to red if the amount is >= to $1,000. I am not a programmer!
Thanks

In design view, select the control.
Then click Format + Conditional Formatting.
As Condition 1 select
Field Value Is
In the next box select
greater than or equal to
Then enter
1000
in the next box.
Select your back color.
Click OK.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.