Gigitty
Member
- Local time
- Today, 02:12
- Joined
- Mar 29, 2007
- Messages
- 52
Hi all.
I have a bunch of yes/no fields on a form and I would like to set the background colour of the associated label when the field value is true. The code i've tried on the first label isn't working properly in that it is setting the background colour for every record not just the record with 'true' values. Total novice at VBA so any help would be appreciated. Have attached a screen shot.
many thanks in advance.
I have a bunch of yes/no fields on a form and I would like to set the background colour of the associated label when the field value is true. The code i've tried on the first label isn't working properly in that it is setting the background colour for every record not just the record with 'true' values. Total novice at VBA so any help would be appreciated. Have attached a screen shot.
many thanks in advance.