Baffled by missing data on printout

[Rick]

I have a bunch of subforms that the user will fill out from a main form. I
then save all that data into a local table, then read it back from a report.
The report loads the same subforms which reload the data. All that is
working fine on screen, and on print preview.

Then, when sent to a printer, all te text boxes are blank! What could
*possibly* cause this? I switched printers, used a pdf output printer (save
to disk in PDF), and with same results. Any ideas?

 

[Mike Painter]

I have a bunch of subforms that the user will fill out from a main
form. I then save all that data into a local table, then read it back
from a report. The report loads the same subforms which reload the
data. All that is working fine on screen, and on print preview.

Then, when sent to a printer, all te text boxes are blank! What could
*possibly* cause this? I switched printers, used a pdf output printer
(save to disk in PDF), and with same results. Any ideas?

You seem to be using report and form interchangeably.
Subforms imply related tables but you only mention one.
If the information you wish to print is in a "local table" do you have a
report which is built on this table or a query relating this table to the
subform tables?

Reports don't use master child relations as forms do and this may be your
problem.

 

[Rick]

No, the only related table is one I use to store form variables, which I
reload manually. Essentially, there are no bound controls. Like I said, it
does show up correctly in print preview, but somehow disappears when
printing it out.

 

[Mike Painter]

You have a REPORT which is based on a SINGLE TABLE and that report shows
correctly in print preview but not when it prints?
Does this happen in all reports?
Does it happen in reports from other databases?

It sounds like some sort of corruption if that is the case.

 

[John W. Vinson]

You have a REPORT which is based on a SINGLE TABLE and that report shows
correctly in print preview but not when it prints?
Does this happen in all reports?
Does it happen in reports from other databases?

It sounds like some sort of corruption if that is the case.

It could also be a problem with the printer driver. Does this happen if you
change printers? If you don't have another physical printer, try the MS Office
Document Image writer or another print-to-file option.

 

[Mike Painter]

It could also be a problem with the printer driver. Does this happen
if you change printers? If you don't have another physical printer,
try the MS Office Document Image writer or another print-to-file
option.

He says it happens when he prints to a PDF.