I inherited an Access 2000 (2002?) database that uses a textbox behind another to change the background color based on two different fields. The Format property is set to: "ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ"[Green];"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ"[Yellow], the Data ControlSource is set to: =IIf([chkCheckedIn]=True,1,IIf([PassExpired]="NO",1,-1))
I understand the IIF(), but what's happening with the crazy characters? (It works the text changes from yellow to green).
I tried replacing it with conditional formatting on the actual data control. That only changes color when I click on the control. The above shows the color all the time.
I understand the IIF(), but what's happening with the crazy characters? (It works the text changes from yellow to green).
I tried replacing it with conditional formatting on the actual data control. That only changes color when I click on the control. The above shows the color all the time.