469,926 Members | 1,767 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 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
1 1059
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

1 post views Thread by Rick Measham | last post: by
6 posts views Thread by Boyd Reilly | last post: by
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.