Print Form without Footer Section

[Mark via AccessMonster.com]

Hi all,

I created a form and hide the record navigator and I created a series of
command button to navigate through the record at the fotter section of the
form. Among these command buttons, I placed a "Print Record Button" on the
form itself to print the current viewing/selected record and when I click on
it, it will print the whole form, with the footer section which contain all
these buttons. Is there a way to exclude the footer section from being print
when I click on the print button?

Thanks

 

[Duane Hookom]

I would not print the form. It doesn't take much time to save your form as a
report and then print the report.

 

[John Spencer]

It can be done. Just set the section's Display When property (on the
format tab) to Screen Only, then if you print the form that section will
not print.

It is usually better to print a report instead of printing a form. You
can right-click on a form object in the database window and choose Save
As and choose Report as the object type. Then you can clean up the
report a bit if you want.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Marko via AccessMonster.com]

Sorry for the late post, I've been away for a bit. Thanks John and Duane.

It can be done. Just set the section's Display When property (on the
format tab) to Screen Only, then if you print the form that section will
not print.

It is usually better to print a report instead of printing a form. You
can right-click on a form object in the database window and choose Save
As and choose Report as the object type. Then you can clean up the
report a bit if you want.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Hi all,

[quoted text clipped - 7 lines]

Thanks