Change Back Colour of a Field

[Trever B]

Hi,

Thanks in advance. Need help on form display.

I have a continous form and the form is based on a query.

In that query I have a many Fields, but three in particular called
'FieldsOrder', 'Area' and another called 'AreaYN'

What I need for the Backcolours to be right when I look at the form.

Rules

if AreaYN = 'Y' Backcolour of Area needs to be Light Red
if Area YN = 'N' Backcolour of Area Needs to be White

However if 'fieldsOrder' = 1 then all fields on that row have to be Light
Green This overides AreaYN.

I need to have the colours show right when I look at the form.

Many Thanks once again

Trev

 

[Marshall Barton]

I have a continous form and the form is based on a query.

In that query I have a many Fields, but three in particular called
'FieldsOrder', 'Area' and another called 'AreaYN'

What I need for the Backcolours to be right when I look at the form.

Rules

if AreaYN = 'Y' Backcolour of Area needs to be Light Red
if Area YN = 'N' Backcolour of Area Needs to be White

However if 'fieldsOrder' = 1 then all fields on that row have to be Light
Green This overides AreaYN.

Use Conditional Formatting (Format menu) on all of the text
boxes. Set the first condition to use Expression Is
[FieldsOrder] = 1
and set the back color property to a light green.

Then set the second condition of the Area text box to use
Expression Is
[AreaYN] = "Y"
and set the back color to a light red.