Textbox changes dependant on value

Lensmeister

Registered User.
Local time
Today, 06:10
Joined
Feb 18, 2009
Messages
65
Hi all,

I have a question related to a textbox on a form.

In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10.

On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating).

What I would like to know how to do is:

If the value in the textbox is 0-5 leave the background colour of the textbox white with black font.
If the value in the textbox is 6-7 turn the background colour pale yellow with black font.
If the value in the textbox is greater than 7.1 turn the background colour Red with white font.

Can anyone help me with how to do this please?
 
Hello,

The contitionnal Formating Menu allows you to do this without problems.
 
I can do that in Excel, but In Access 2002 ?
 

Users who are viewing this thread

Back
Top Bottom