WHY records print blank columns

[Guest]

I have several tables and reports in Access with many columsn with yes/no
checkboxes. I have been able to print these tables before and the checkboxes
appear in the printout whether checked or not. I am trying to print a report
based on the table or query. The information is correct when viewed on the
screen but the report only shows the column headings and the rest is blank.

 

[BruceM]

Does your report have check box controls bound to the Yes/No fields? When
you say the information is correct when viewed on the screen, do you mean
that the report on the screen shows the check boxes, or do you mean that the
table on which the report is based shows the check boxes, but the report
itself does not?

 

[Joan Wild]

Are you printing in 'draft' mode? You'll need to use Standard instead -
checkboxes won't print in draft in my experience. It might also be a
printer driver problem. Do you have the latest drivers for your printer?

 

[Guest]

The report shows the checkboxes on screen but not on paper when I try to
print it.

 

[Guest]

The checkboxes print if I print the entire table. If I select several
records and print selection they do not print nor do they print when I print
from a report.

 

[BruceM]

Again, does your report have check box controls bound to the Yes/No fields?
Are you actually printing a report as it is defined and categorized in
Access?

 

[John Vinson]

I am trying to print a report based on the table or query.
The information is correct when viewed on the screen but the
report only shows the column headings and the rest is blank.

Sounds like you might have a problem with a printer driver! Is this a
new printer, or have you changed its printer driver recently? Do you
have another printer (perhaps the built in Fax printer) you can use to
test this report?

John W. Vinson[MVP]

 

[Guest]

Sorry I am a bit of a novice and not sure what you are referrring to. I set
up a table with several fields having the data type set at Yes/No. From this
table I went to Reports and using the Report Wizard created a report to
display among other fields these ones with the Yes/No checkbox which displays
accurately on my monitor but is completely blank when printing.

 

[Guest]

It is not a new printer and the fields print with the checkboxes either
checked or unchecked if I print the full table, if I select only a few
records they print without the checkboxes

 

[BruceM]

OK, so you are definitely using a report as set up by the report wizard.
Others in this thread have suggested a printer driver issue, so I will leave
you to those parts of the thread, but just for the heck of it, use the
toolbox (View > Toolbox) to add a check box to the report. Just plunk it on
there and see if it prints.

 

[Guest]

It printed the label Check 26 but not the checkbox. I do not have a new
printer, nor have I changed anything about my printer. I can print this
table in full and the checkboxes appear properly (check or unchecked as
necessary), however if I select a few records the checkboxes disappear
completely.

 

[BruceM]

Time for some troubleshooting. Click on the Reports tab in the database
window (the thing that probably shows up when you open a database, with
tabls for Tables, Queries, etc.). Double click Create Report in Design
View. You should see a blank form and a box with Report on the top and five
tabs: Format, Data, etc. If you don't see it, click View > Properties.
Click the Data tab. Click into the Record Source row, and use the down
arrow at the right side of the row to select your table. Drag one of your
Yes/No fields onto the report, switch to Report View (i.e. not Design View)
and try to print the report.

Have you ever printed a report with check boxes? If not, this could still
be a printer driver isue.

 

[Guest]

The checkbox printed using your troubleshooting below. I don't believe I
have printed a REPORT with checkboxes only tables.

By the way thank you so much for taking the time to work on this with me.

 

[BruceM]

This strikes me as rather a curious phenomenon, but there it is.

You could try just copying everything (or selected elements) from the
wizard-generated report and pasting it into a new report that uses the same
Record Source, or you could try a new wizard-generated report, or you could
just create your own. I'm not a big fan of the wizards, but they can be
convenient in some cases. Anyhow, you know that a check box control will
print, so you can probably devise a solution. I will keep monitoring this
thread for a while, so post again if you hit a snag. In the meantime maybe
somebody will recognize what's going on with the check boxes.

 

[Guest]

I know you said you were going to be checking back to see my progress so I
thought I would let you know this is a complete mystery but this morning I
opened my report in design view in the attempt to print the set up so that I
could recreate the exact set up without using the wizard. Well it printed my
entire report (22 pages) with appropriate checkboxes in place!!! I am in the
dark on this one but not complaining as I have my report! Again, thank you
for all your help. If I need to make any changes and have complications may
I contact you?

 

[BruceM]

Glad to hear it's working. It didn't occur to me to suggest rebooting even
though it's probably one of the things I would have tried.
The best place to post questions is right here in the newsgroup. I am a
comparative amateur, and while I can help in some cases you would have the
best chance of your question being seen by a truly knowledgeable person if
you post it to the group. Also, days at a time go by when I don't have much
chance to spend time on things outside of the project on which I am working.