Yes/No format and check boxes

[mocamira]

Hi,
I am doing a query in which I input a formula IIf(Value>0,Yes,No) and would like to see the results appear as check boxes ticked or unticked instead of lists of Yes and No.
Apparently there is a way to change the format in the properties but I can't see how!
Any ideas???
Cheers

 

[maxmangion]

go to the design view of the table which you are querying click on the yes/no field, and then in the lower pane of the design view click the Lookup tab and select check box from there. however usually by default it is already set to check box.

 

[namliam]

As far as i know this is only "doable" with fields in table or form not in query... In query you can pick and choose between Text/Combo/list but that is all as far as i know...

Regards

 

[mocamira]

That doesn't really work...

That doesn't really work because I don't want a Yes/No Field in the table. I want it to change in the query depending on the result of the IIf function so that If I change the value in the table and the IIf function result is "No" it unchecks the box in the result of the query.
Thanks anyway!

 

[Rich]

It doesn't matter how the field is displayed in the table, Yes/No, True/False, -1/0 all mean the same. You shouldn't enter data directly into a table anyway, use a form for data entry