Force display of calulated Boolean field as checkbox

[spikepl]

I have a select query concocted from a number of tables, that will be exported to Excel. I have a number of Boolean fields, that nicely display as a checkbox. I have a calculated Boolean field, and I have so far not found a way to display it as a checkbox, instead of True/False, Yes/no, or On/off.

Without creating a redundant field in one of the tables, how can I force the DisplayControl to be a Checkbox? It only offers Textbox, Combobox or Listbox - apparently being convinced that I am dealing with a string.

 

[John Big Booty]

Change your calculated field to return -1 instead of True and 0 instead of False, then use your caclulated field as the Control Source for your check box.

 

[vbaInet]

I think spikepl is talking about displaying it in the query.

I don't think this can be done unless you use a form and an actual check box control. The You can always set the form to Datasheet to make it look like a query.

The check box control is only associated with the Yes/No data type and since there's no way to cast to a Yes/No data type the check box option will not be available.

 

[John Big Booty]

I think spikepl is talking about displaying it in the query.

I don't think this can be done unless you use a form and an actual check box control. The You can always set the form to Datasheet to make it look like a query.

The check box control is only associated with the Yes/No data type and since there's no way to cast to a Yes/No data type the check box option will not be available.

My bad, I misunderstood what he was attempting