Conditional formatting

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.

--
Steve Schapel, Microsoft Access MVP

John wrote:
Hi

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

Thanks

Regards

Hi

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

Thanks

Regards

"Steve Schapel" wrote in message
...
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.

--
Steve Schapel, Microsoft Access MVP

John wrote:
Hi

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

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" wrote:

Hi

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

Thanks

Regards

"Steve Schapel" wrote in message
...
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.

--
Steve Schapel, Microsoft Access MVP

John wrote:
Hi

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

Thanks

Regards