Change Color of BackColor in Label with vb code?

[hefly]

I would like to change the back color of a text box on a form if a condition in my query is met.

Qry_Colors

If [qry_colors].[FieldA] = [qry_colors].[FieldA],
then backcolor of TxtBox named Lease_no = #FF0000, otherwise backcolor = #FFFFFF

Thank you!

Hefly

 

[MajP]

look in the help file under conditional formatting.

 

[dhookom]

Isn't this always going to be true:

[qry_colors].[FieldA] = [qry_colors].[FieldA]

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

LOL

A sharp eye dhookem. Yes.

I meant to write [qry_colors].FieldA = [qry_colors].[FieldB]

I've been trying to write the query I want, but I think the correct way to do it is to apply conditional formatting to a DLookup value in tableA.

If [qry_1].[String] exists at least once in [tbl_1].[String], then the background color changes.

Thanks dhookem