467,075 Members | 1,026 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

changing colors of numeric fields

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

Nov 13 '05 #1
  • viewed: 1015
Share:
1 Reply
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by bill mahoney | last post: by
4 posts views Thread by Starbuck | last post: by
5 posts views Thread by Stick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.