Hide fields fon MS Acess 2007 Form from being printed

[jker]

I have a form and it uses a print button. When I press it, it prints all the fields on my screen.



IS THERE ANY WAY, using an event, that I can hide/prevent certain field from appearing on the report?

[Bob Fitz]

Show us the code that is used in the On Click event of the button

[xps35]

Do not print a form, make a report. That is where reports are for. You can choose which fields you want to print on the report.

[CJ_London]

agree - use a report, but to answer your question - review the display when option format property

[Gicu]

In addition to the above answers I would add that if the intention is to dynamically (or conditionally) show\hide the controls (bound to fields) depending on certain values of other controls you would need to add code to the Format or Print events of the report section that contains the controls.

Cheers,