Report layout

Hi,

How do I get the report preview to show maximized and at 80%

Thanks,
J.

Just go:

docmd.OpenReport "name of report",acViewPreview
docmd.Maxmimize
DoCmd.RunCommand acCmdZoom75

I don't think there is a zoom80, but 75 should be close...

Note that you can put the docmd.Maximize in the reports on-open event (all
mine do that), the zoom command has to be executed *after* the report loads,
and thus needs to follow the openreport command in code as above...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

I get Run-time error '2046':
The command or action Zoom75%' isn't available now.

"Albert D. Kallal" wrote in message
...
Just go:

docmd.OpenReport "name of report",acViewPreview
docmd.Maxmimize
DoCmd.RunCommand acCmdZoom75

I don't think there is a zoom80, but 75 should be close...

Note that you can put the docmd.Maximize in the reports on-open event (all
mine do that), the zoom command has to be executed *after* the report
loads,
and thus needs to follow the openreport command in code as above...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

also how do I run down the left half of A4 page then resume at the top and
go down the right?
Thanks,
"Albert D. Kallal" wrote in message
...
Just go:

docmd.OpenReport "name of report",acViewPreview
docmd.Maxmimize
DoCmd.RunCommand acCmdZoom75

I don't think there is a zoom80, but 75 should be close...

Note that you can put the docmd.Maximize in the reports on-open event (all
mine do that), the zoom command has to be executed *after* the report
loads,
and thus needs to follow the openreport command in code as above...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

Jason" wrote in message
...
I get Run-time error '2046':
The command or action Zoom75%' isn't available now.

do you have any prompts in your sql code (parameters), or perhaps some type
of message box?

the report's on open event code HAS TO FINISH. Actually, likely it means the
report needs to have finished being rendered before you execute the
DoCmd.RunCommand acCmdZoom75

Post your 2-3 lines of code you using to open the report.

I suspect if you have any type of dialog prompts, or parameters, then you
need to change your approach...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

"Jason" wrote in message
...
also how do I run down the left half of A4 page then resume at the top and
go down the right?
Thanks,


Do you mean you want two columns of data? You have to "ensure" your layout
is LESS then 1/2 the available space, and then in page setup, you see the
options for specifying the number of rows for your data.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

There's no prompts but there is a function called from the SQL that is the
form's data.
"Albert D. Kallal" wrote in message
...
Jason" wrote in message
...
I get Run-time error '2046':
The command or action Zoom75%' isn't available now.

do you have any prompts in your sql code (parameters), or perhaps some
type
of message box?

the report's on open event code HAS TO FINISH. Actually, likely it means
the
report needs to have finished being rendered before you execute the
DoCmd.RunCommand acCmdZoom75

Post your 2-3 lines of code you using to open the report.

I suspect if you have any type of dialog prompts, or parameters, then you
need to change your approach...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

There's no prompts but there is a function called from the SQL that is the
report's data.
"Albert D. Kallal" wrote in message
...
Jason" wrote in message
...
I get Run-time error '2046':
The command or action Zoom75%' isn't available now.

do you have any prompts in your sql code (parameters), or perhaps some
type
of message box?

the report's on open event code HAS TO FINISH. Actually, likely it means
the
report needs to have finished being rendered before you execute the
DoCmd.RunCommand acCmdZoom75

Post your 2-3 lines of code you using to open the report.

I suspect if you have any type of dialog prompts, or parameters, then
you
need to change your approach...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada