Conditionally Format Table Rows

[surfbum3000]

Table Name: tblLongDrive
Field Name: Status

I want to highlight in Red when the Status=Telco Msg. I created a query and entered the code in the Field Name area.

If {tblLongDrive.Status} = {tblLongDrive.Telco Msg} Then crRed Else crBlack

What error have I made?

If it seems like I don't know what I am doing it's because I don't

 

[PHV]

While in the Form Design View take a look at Conditional formatting.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[surfbum3000]

Thanks. I created a Form in datasheet view and used Conditional Formating.