Printout of open form in landscape format

[P]

Hi,

Access 2002. I am trying to use the PrintOut function to print the current
record of the current open form in landscape format to the default Windows
printer. Any suggestion on how to set the printout to landscape mode? Thank
you. P

[Graham Mandeno]

Hi P

Create a report based on your table(s) displaying the fields you want
printed, and format the report exactly how you want it - page orientation,
margins, etc. If the required layout is similar to your form, then you
could start with File>Save As>Report.

Now, place a command button on your form, named cmdPrintCurrentRecord, and
in its Click event procedure put this code:

DoCmd.OpenReport "name of report", _
WhereCondition:="[name of primary key field]=" _
& Me.[Name of primary key field]

If your primary key is a text field, you will need to wrap the value in
quotes:
...
& chr(34) & Me.[Name of primary key field] & chr(34)

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"P" <P@no_spam.com> wrote in message
news:%7********************@newssrv26.news.prodigy .com...

Hi,

Access 2002. I am trying to use the PrintOut function to print the current
record of the current open form in landscape format to the default Windows
printer. Any suggestion on how to set the printout to landscape mode? Thank you. P