Carbon Copy Form Printing

[data10]

I have searched all over google for help on this one, so now I enlist help from the good folds at the MS Access Help Center...

I have been given the task of updating a particular form our company has been using for over 10 years. The form was originally created to print on color coded carbon copy form with 5 sheets of paper. The form gets printed via a dot matrix printer (which pounds thru all 5 sheets). At this time, the form is done in MS Access 97 - and simply prints all fields via the print command.

Certain sections of the form do not print on all copies because the carbon copy paper masks the fields. I.E. the bottom sheet does not show the 'bill to' information but all other copies do.

So, I was asked to make the existing form print to our standard Laser Jet printers - but to hide certain items per page. I have determined how to print the form 5 times by simply adding some basic VB code to a command button. What I can't figure out is how to hide certain fields as the old carbon copy form once did. I.E. Print the same page of a form 5 times, but each page has different information on it per page.

Any help would be appreciated - thanx

 

[Laurentech]

Interesting problem. You could either create five different reports, each one with the fields in question removed, and print them one after another, or set up a variable on the form that calls the report, say PrintNum, that you check in the OnFormat event of the detail section to see which fields to make not visible.

Larry