Running a report with Checkboxes

[saultpastor]

I have a form that uses several check boxes, this works well when using the edit form, but not so well with a report. Is there a simple way to change the 1 or 0 to an X or a check mark?

Craig

[admin]

Craig,

I'm not sure exactly what you are asking.

Steven

[saultpastor]

I'm sorry, When I run a report, a checkbox gets posted as a 1 or a 0. Is there a simple way to convert this to an X if 1 is present or null if 0 is present?

This is the edit form:


This is the Report output:


It must something that is dealt with all the time I just can't seem to find it.

Thanks

[admin]

saultpastor,

The easiest way would be to use a Dropdown or Listbox (instead of a checkbox) with the following in the SQL field..

Code: Select all

|No|X|Yes

t1.png

t2.PNG

Steven

[saultpastor]

OK, Thanks.

[admin]

.