Hello everyone,
I've got a quick question. I've got two check boxes on a form. Each one has a long label. Depending on the value of a field in my table, I want one of them to show as checked. The field is a short text field. I've tried some logic like this:
Code:=iif([TableA]![fieldA]="In",TRUE,FALSE)
So if fieldA="In", I want the first checkbox to show as checked. if fieldA="Out", I want the second checkbox to show as checked.
Any suggestions?