Exporting an Access report to Excel

  • Thread starter Thread starter Stanley
  • Start date Start date
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
 
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
 
Back
Top