Print Button prints out a form different from the one showing on the screen

I have an input put screen which users use to enter numerous fields of data. The form layout has numerous colors and notes to make sure data is input correctly. When you print the forms it is not designed to fall onto on 8.5" 11" page and has color background, and other notes not needed for the form printout but helpful for the data entry.

I would like to have a print button that prints one form of the data being displayed on the screen but actually prints the data using a different form without all the background and unnecessary notes and clutter. It would be black and white only and fall nicely to one page.
I'm very limited with Access but have done some recorded macros in Excel which has helped me get around lack of coding skills, maybe that could be done here.

Also, I did not create the db and was wondering if the developer could easily email the form I need to modify so I could help create the plain black & white version of the form.

Appreciate any direction. J

Hi JET2011,

A technique I use in cases like yours is to have a 'Scratch' sheet for printing. A macro copies the data required from the original sheet to the scratch sheet en masse or one cell at a time. You can format the scratch sheet with font types, font sizes, font styles (bold, italics, etc.) as you required. Headers and footers and page layout are also doable. The macro recorder can help you get started with all of these tasks.

The macro recorder use '.Select' quite often which is usually not needed.

Here is some sample code:

Please Login or Register  to view this content.

When you get stuck on how to copy or format something, an internet search often comes up with excellent answers.

I hope this helps.

Lewis

Thank you, I'll give it a try. It will be a while until I can work with it.

j