Show check box as yes/no text on a report 2

[JSD]

Hi

I've been trying to change a check box display as 'yes' or 'no' on a report. Any help would be most appreciated.

Thanks

 

[TomCologne]

SELECT DISTINCTROW tbl1.Date, "Yes" AS Displ
FROM tbl1
WHERE (((tbl1.Choice)=-1));

This is a very basic sample that displays "Yes" where records are checked. Field "Date" is just a control, "Choice" the checkbox field and "Displ" as the function. This is a copy&paste of a qry in SQL view, in Design view it's no more than pulling "Date" and "Choice" into the grid, criteria for choice set to -1 & Show unchecked, plus
Displ:"Yes".

Certainly more of an inspiration than a solution, at least

you're not alone,

TomCologne

 

[JSD]

Hello

Thanks a lot. That worked great. One step closer to completeing this adventure.

Jeremy

 

[mikey69]

The quick & dirty fix is to do it in the query grid, using the Iif function. OutputName: Iif([Field] = -1,"YES","NO&quot.

Then use OutputName as the control in your report.

Works well but might be slower in a huge recordset.

 

[jebry]

Hi Jeremy!

I don't know if you are still listening or not but the simplest thing to do is to put a text box on the form or report and make the control source your check box field. Then go into the format tab of the property sheet and on the format line click the drop down arrow and select Yes/No.

hth
Jeff Bridgham
bridgham@purdue.edu