Format yes/no box

[myhnews]

How to I format a check box, to display on the report as Yes/No ?
Thanks
Joe

 

[GUIDO22]

Add the check box to the report and set its visible state to 'No'
Then add a text box to the report whose 'controlsource' contains :

=Iif(chkBox.Value=-1, "Yes", "No")

This should do the job.

 

[Rich]

Please just post once on the subject!
http://www.access-programmers.co.uk/forums/showthread.php?t=97576