How to Export Checkbox to an Excel

[nyamrembo]

Hi,
I have an access report that has a checkbox field on it and I want to export this report to an Excel spreadsheet. But when I export the report, the checkbox part on the report does not show up on the excel. Does anyone know how I can a achieve this or if there is a better option.

Thanks,

 

[dhookom]

The bound check box probably shows up as 0 or -1. I don't believe you can push the check box control to Excel.

Duane
Hook'D on Access
MS Access MVP

 

[nyamrembo]

Thanks for the info. Now I am thinking about displaying the checkbox value as line if condition is false. If I can accomplish this, then there will be no need to export to excel. Do you know how I can do this and where would the code go on the report?

Thanks again,

[Sunshine]

 

[nyamrembo]

I got it figured out. Made the checkbox invisible then added a label with a line which will on show the line if the checkbox is false.

Happy Holidays to All of you wonderful people at Tek-Tips