split form Yes/NO

[Jason F]

I'm using a split form, This form has yes/no bullets. In the datasheet part
of the split form the column containing the Yes/No selection reads "-1" or
"0" How do i display "YES" or "NO"

Thanks
Jason

 

[KARL DEWEY]

Open form in design view, click on the object, right click and select
properties located at bottom of the list. Scroll to Format and select Yes/No.

 

[ANDY-N via AccessMonster.com]

Open form in design view, click on the object, right click and select
properties located at bottom of the list. Scroll to Format and select Yes/No.

You could use Yes/No Selection: iif([field]=-1,"YES","NO") in the datasheet
to display YES or NO instead of -1, 0 which will solve the problem.