Page orientation and pop up confirmation

[jon]

Can anyone provide VBA code or a solution for the
following:

I would like to print a form by using a button on it that
not only
prints the form but also changes the page orientation to
landscape
when i click it.

I am going to place a save button on a form and would like
a
confirmation box when I press the button. It would be good
if the
confirmation box would disappear by itself after a short
delay.

cheers for your help

Jon

 

[Steve Schapel]

Jon,

Whereas it is possible to print a form in Access, this is not the
purpose of forms, the functionality is very limited, and any attempts
to do so are bound for frustration. I would recommend that you make a
report for printing. This is what reports are for. Certainly you can
use the current form record, if applicable, in the criteria of the
query that your report is based on.

Regarding your other question... er, what's a confirmation box?

- Steve Schapel, Microsoft Access MVP