Controls on print preview

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

How can I prevent my buttons and controls at the Form
Header, from being displayed on print preview and from
being printed?

Thanks
Joe
 
Hi

Normally forms are for viewing data and reports are for printing the data. You
should consider creating a report to print the desired data.

Maurice
 
Unfortunately, Joe, Access doesn't provide much control of
printing a form. Reports are the best way to control
printed output. In your case, you could add a command
button if you don't have one to Preview the report. The
report's underlying query could then reference the
appropriate form control to preview only the current
record.

For example, the criteria for the key field of the
report's underlying query would be something like:

=Forms!yourformname!yourkeyfieldcontrolname

HTH
Kevin Sprinkel
 
How can I prevent my buttons and controls at the Form
Header, from being displayed on print preview and from
being printed?

Thanks
Joe
Click to expand...
If you must print the form (a report would be better),
each control has a 'Display When' property (on the Format Tab).
Set it to 'Screen only'.
 
Back
Top