Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

JSD

Technical User
Jan 18, 2002
189
US
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
 
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
 
Hello

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

Jeremy

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

Then use OutputName as the control in your report.

Works well but might be slower in a huge recordset.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top