Conditional Formatting

[kirstie adam]

Hi,

I have a form which is a continous form and shows line after line of
records.
I have 2 fields on it

[Survey Required] - it's a check box
[Date Survey Ordered] - a date field

If [Survey Required] is yes and [Date Survey Ordered] is blank i want [Date
Survey Ordered] to have red back color.

Can someone give me the coding for this?

At the moment i have:

If Me.Transport_Survey_Req_d = "-1" Then
Me.Transport_Survey_Results_Received.BackColor = 255
Else
Me.Transport_Survey_Results_Received.BackColor = -2147483643
End If

but this highlights each record red even if it shouldn't be!!

Thanks,

Kirstie

 

[Arvin Meyer [MVP]]

In Access 2000 and later, you can apply Conditional Formatting to a control
based on its own value (not the value of another control). You also might
try Stephen Lebans site:

http://www.lebans.com/formatbycriteria.htm

 

[Ron2006]

Actually it CAN be based on another control.

sit on the "Date_Surveyed" field and select conditional formating

Change the item on the left from "field value" to "Expression"

in the expression box enter:
[Transport_Survey_Req_d] = true AND isnull([Date Survey Ordered] )


then select the formating you want (the red background).

Ron

 

[Arvin Meyer [MVP]]

Very good!
Thanks,

 

[kirstie adam]

excellent, off to try that, thanks!