Check Boxes

[northernbreaks]

Hi
In my tables I have set a field to Yes/No and the format to be True/False.
When I activate the table it shows the field as a checkbox, however when I create a List Box on a form to that table it displays the fields as True/False, how can I get the list box to also display the field as a checkbox.


dave

 

[Sergeant]

Put a query between your form and table.
Use an expression like this for a query field:

MyCheckBox: IIf([MyTrueFalseFieldName],"√","")

Now you can refer to that field from anywhere on your form.

Get the checkmark character from Excel or Word if this doesn't copy correctly.

 

[northernbreaks]

check boxes

Thanks for the tip


Dave