I require to add a background colour, eg Green for "solved" and red for "open", to a form field based on the selection from an option box for that field.
Any advice please?
BenHPieters
I require to add a background colour, eg Green for "solved" and red for "open", to a form field based on the selection from an option box for that field.
Any advice please?
BenHPieters
Yes it does. For example:
Alternatively, use the AfterUpdate event for the Option Group:
Either will work fine for a single record but will affect ALL records if it is a continuous form.Code:Private Sub Frame11_AfterUpdate() Select Case Me.Frame11 Case 1 Me.Field1.BackColor = vbGreen Case 2 Me.Field1.BackColor = vbRed End Select End Sub
If your want to mark records individual records on a continuous form as solved/open, add a boolean field with a checkbox
Then use event code or CF like that above but based on the checkbox value
Hope that helps
Last edited by isladogs; 02-06-2019 at 08:17 AM.
Thank you, I simplified the field option to "completed" and "in progress" and using AfterUpdate (1) and your Case options, it works.
Thanks for that.