Controls on print preview

[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

 

[StCyrM]

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

 

[Kevin Sprinkel]

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

 

[fredg]

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

Thanks
Joe

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'.

 

[Kevin Sprinkel]

Thanks, Fred. I didn't know this property was available.

Kevin Sprinkel

 

[Art]

Hi Joe

Set the "Display When" property on the control or button

HOPE THIS HELPS