D
Darke
Guest
I want to use the values in a table to control the way labels appear in a form using the form_load procedure. I have a boolean value (yes/no) in a table that I want the procedure to lookup for each value in a table, and then in the corresponding label on the form, I want it to change the background color accordingly. Ie;
Table: Tablename
ID Yes/No
1 Yes
2 No
3 No
4 Yes
5 No
-----
Form Properties:
Label1.backcolor = Blue
Label2.backcolor = Red
Label3.backcolor = Red
Label4.backcolor = Blue
Label5.backcolor = Red
Any suggestions on how to get this to work in access? Or am I approaching it from the wrong direction?
-Darke
Table: Tablename
ID Yes/No
1 Yes
2 No
3 No
4 Yes
5 No
-----
Form Properties:
Label1.backcolor = Blue
Label2.backcolor = Red
Label3.backcolor = Red
Label4.backcolor = Blue
Label5.backcolor = Red
Any suggestions on how to get this to work in access? Or am I approaching it from the wrong direction?
-Darke