Exporting an Access report to Excel

S

Stanley

I have a report with check boxes on it. When I export it to Excel 2002 I get
all the fields except the checkboxes (I would be happy if a got -1 and 0).
Any ideas less than changing the report to have text boxes for these fields
instead of check boxes.
Thanks,
Stan
 
M

Mark A. Sam

Try using a calculated control which hold that value of the checkbox. For
example name it [txtMyCheckbox] (where MyCheckbox is the checkbox name).
For the controlsource property, =[MyCheckbox]. I am assuming you are using
the TransferSpreadsheet Method (or Action) and not VBA.

God Bless,

Mark A. Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting an Access report into Excel 2
Exporting data from Access to Excel 2003 with combo box problem 1
Filtering a Query then Exporting to Excel using VB 1
exporting graphics to Word 2
How do I export a report to Excel in Access 2007 1
Export to XML - error 31532 0
Exporting Basics 2
Access MSACCESS - Sorting report based on field calculated in the report 0

Top