Check Boxes Yes/No

[Roger Bell]

I have several Yes/No fields on a report and have used the Windings Font so
that a Tick appears with out the box.

Is there any way I can change the Tick on the report to an asterisk *

Thanks for any help

 

[John W. Vinson]

I have several Yes/No fields on a report and have used the Windings Font so
that a Tick appears with out the box.

Is there any way I can change the Tick on the report to an asterisk *

Thanks for any help

If it's a Yes/No (Boolean) field in the table, use

=IIF([fieldname], "*", "")

as the Control Source of the report textbox.

John W. Vinson [MVP]