Conditional formatting

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I colour a calculated field on a form based on its numeric value?

Thanks

Regards
 
John,

By the Subject of your post, it seems that you are aware of the
Conditional Formatting functionaliity available in Access for just this
purpose. Why isn't that working for you? You might need to give some
more details, such as the name of the control, where you are doing the
calculation (e.g. query, control source), what is involved in the
calculation, what you have tried so far, and what you want. Thanks.
 
Hi

The field is a text box on a form with an expression =[field1]-[field2] as
Control Source.

Thanks

Regards
 
As Steve asked, what have you tried?

1. Place your cursor in the textbox
2. Select Format, Conditional Formatting from the main menu (2003)
3. In Condition 1,
a. Select "Field value is"
b. Select "Less than"
c. Enter a numeric value (make sure it is a value that you know you
have [Field1]-[Field2] values less than this value).
d. Click on the "Background" button (right after underline) and select
a background color.
e. Click OK

Now open your form and browse through the records. If you have a record
where the values of [Field1] - [Field2] is less than the value you entered,
its background color should be whatever color you selected.

Dale

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



John said:
Hi

The field is a text box on a form with an expression =[field1]-[field2] as
Control Source.

Thanks

Regards
Click to expand...
 
Back
Top