Queries/forms

[idowu100]

I am trying to create a report, I have a combo box with Voluntary Restriction Date, Restriction Imposed Date. The information required from this report is when the user choses a date from either of these boxes the information relevant to that date is displayed on the datasheet view.

I also have a combo box with -1 and 0 which in the form is displayed as a checkbox but on the table -1 and 0 is displayed.
I need to be able to display the word yes or no rather than -1 and 0 in the combo box.

I have attached the file that I have problem with. The report is called frmReport. the actual table is Incident.

 

[Rich]

Delete the checkbox on the report, add an unbound textbox set the control source to your field and select yes/no as the data type