Hi! I have a continuous form with a list of names, and an active (vs inactive) checkbox. I would like to have conditional formatting based on whether the Active checkbox is ticked or not.
My conditional formatting is set as "Expression Is: [Active]=0".
Any ideas why this is not working for the other fields?
- I would prefer the formatting to change for the background of the detail itself (continuous form, so highlighting the 'inactive' records), but that seems to be quite difficult and I can't find the right VBA code for it. If you have any suggestions, I would appreciate it. I'm not sure if the code should go in the Form Load or somewhere else, given it does not apply to the detail on every record, only certain records.
- My alternative which is also acceptable is for the other fields in the same record. I realize that some fields cannot be formatted differently (such as checkboxes), but there are other text boxes / combo boxes in each record.
My conditional formatting is set as "Expression Is: [Active]=0".
Any ideas why this is not working for the other fields?