Reports and text boxes

I have a resourse databse with many check boxes. When I try to generate a
report I either get -1 or 0; or yes or no. How do I get the report to show
only the yes's and as X's in the report??

I appreciate any help anyone can give me.... I'm getting frustrated!!!!

Kerri

On Thu, 2 Aug 2007 13:10:05 -0700, Kerri wrote:

I have a resourse databse with many check boxes. When I try to generate a
report I either get -1 or 0; or yes or no. How do I get the report to show
only the yes's and as X's in the report??

I appreciate any help anyone can give me.... I'm getting frustrated!!!!

Kerri

Add a text control to the report, bound to the Yes/No field.
As it's Format property write:
; "X";

An "X" will appear only if the value is -1. Nothing will appear if the
value is 0.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail