Conditionally change backround color of detail section when [TimeInspStart]<>"" ?
I have used textboxes moved to the back of the detail section for this before but it is not going to work for this particular situation as a user can easily accidentally click on the backround and cause the box to become active. (When setting conditional formatting on a textbox that has Enabled set to false, when it the conditional formatting applies a color to the box, it then becomes enabled and allows the users to click on the box.
I just want to set some kind of vba for the form that will highlight the line in the detail section whenever my different criteria is met.
So maybe something like whenever [TimeInspStart] <> "" then change the backround color blue.
Thanks in advance for the advice.
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst