nuBuilder Forum

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

Craig,

I'm not sure exactly what you are asking.

Steven

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

saultpastor,

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

OK, Thanks.

.