Field colours in a form

[Martin hopkins]

Hello,

Could you please advise how I can set the colour of a field on a Access
form, depending on what text is entered.

For example, in my form I have 5 day fields, Mon - Fri for each of my
students. I can then enter the following values into the desired day for
each student:

Guitar or Drums or Violin

Then I can quickly rwad what is palnned for each week with each student. I
would like to enhance this by changing the background colour of the field,
dependant on the text entered:

eg If I enter G for guitar then the field changes colour to Green, D for
drums then set colour to Blue, and V for violin set colour to Red.

This would give me a pictorial view.

Any help greatly appricated.

Martin Hopkins

 

[fredg]

Hello,

Could you please advise how I can set the colour of a field on a Access
form, depending on what text is entered.

For example, in my form I have 5 day fields, Mon - Fri for each of my
students. I can then enter the following values into the desired day for
each student:

Guitar or Drums or Violin

Then I can quickly rwad what is palnned for each week with each student. I
would like to enhance this by changing the background colour of the field,
dependant on the text entered:

eg If I enter G for guitar then the field changes colour to Green, D for
drums then set colour to Blue, and V for violin set colour to Red.

This would give me a pictorial view.

Any help greatly appricated.

Martin Hopkins

In Access 2000 or newer, use the Control's conditional formatting
property
Format + conditional Formatting