WANTED - Access Expert - Yes/No field type on reports

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

How can I get a Yes/No (checkbox field) to display in
Excel when exporting from an Access Report? Any checkbox
field on my report does not export over to an Excel file -
there is nothing displayed. It works from a query
(displayed as True or False) and the query is the data
source of the report, but I need it to work from a report
export. I am using Access 97. Thanks!
 
Lori said:
How can I get a Yes/No (checkbox field) to display in
Excel when exporting from an Access Report? Any checkbox
field on my report does not export over to an Excel file -
there is nothing displayed. It works from a query
(displayed as True or False) and the query is the data
source of the report, but I need it to work from a report
export. I am using Access 97. Thanks!
Click to expand...

The CheckBox is a graphical element and as such none of the export formats
will include it except for Snapshot Format. Format your report to use
"Yes/No" or "True/False" instead and then it will work.
 
How can I get a Yes/No (checkbox field) to display in
Excel when exporting from an Access Report? Any checkbox
field on my report does not export over to an Excel file -
there is nothing displayed. It works from a query
(displayed as True or False) and the query is the data
source of the report, but I need it to work from a report
export. I am using Access 97. Thanks!
Click to expand...

Use a Textbox formatted Yes/No or True/False instead of a Checkbox
control on the report. A True/False field type is not stored "as a
checkbox" - it's a small integer, with -1 for TRUE and 0 for FALSE.
The checkbox is just one of the choices for display.
 
Thanks for the advice...I changed it to a text box - how
can I make it so Yes or No appear instead of -1 and 0?
 
Back
Top