Open Reports in Maximum Print Preview

[Uschi via AccessMonster.com]

Is there a way to have the report open in Maximum print preview instead of
the report opening and then clicking the maximize button at the top of the
page?

Thanks for your help.

 

[Marshall Barton]

Is there a way to have the report open in Maximum print preview instead of
the report opening and then clicking the maximize button at the top of the
page?

If you use code (behind a command button on a form?) to open
the report, add:
DoCmd.Maximize
right after the OpenForm line.

 

[Steve]

OpenForm will not open a report!

Also, the OP wants to open a report in Print Preview!

 

[Gina Whipp]

Uschi,

Ooops, I am sure Marshall meant OpenReport... Try this

DoCmd.OpenReport "NameOfYourReport", acViewPreview
DoCmd.Maximize

However, if you need the report to open a specific record, use...

If field is TEXT

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=" &
Me![NameOfFieldOnForm]
DoCmd.Maximize

If field is NUMERIC

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=' " &
Me![NameOfFieldOnForm] & " ' "
DoCmd.Maximize

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve]

Wrong!!

The code for text and numeric should be reversed.

Uschi,

Ooops, I am sure Marshall meant OpenReport... Try this

DoCmd.OpenReport "NameOfYourReport", acViewPreview
DoCmd.Maximize

However, if you need the report to open a specific record, use...

If field is TEXT

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=" &
Me![NameOfFieldOnForm]
DoCmd.Maximize

If field is NUMERIC

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=' " &
Me![NameOfFieldOnForm] & " ' "
DoCmd.Maximize

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Uschi,

I did made an Oops, the TEXT and NUMERIC should be reversed. I guess both
Marshall and I need more coffee!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Uschi,

Ooops, I am sure Marshall meant OpenReport... Try this

DoCmd.OpenReport "NameOfYourReport", acViewPreview
DoCmd.Maximize

However, if you need the report to open a specific record, use...

If field is TEXT

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=" &
Me![NameOfFieldOnForm]
DoCmd.Maximize

If field is NUMERIC

DoCmd.OpenReport "rptBoL", acViewPreview, , "[NameOfFieldInReport]=' " &
Me![NameOfFieldOnForm] & " ' "
DoCmd.Maximize

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Keith Wilby]

Wrong!!

You really are a child aren't you $teve? Read one of your reference books
and see if there's a chapter on how to behave like a mature professional.

 

[Uschi via AccessMonster.com]

Yikes! What have I started here?

Marshall, everything is fine. I looked at the code and I knew what you meant.

Here's my code:

stDocName = "Current Membership Report"
DoCmd.OpenReport stDocName, ac Preview
DoCmd.Maximize

It works like a charm.

Thanks so much,
Uschi

Uschi,

I did made an Oops, the TEXT and NUMERIC should be reversed. I guess both
Marshall and I need more coffee!

Uschi,

[quoted text clipped - 27 lines]

 

[Uschi via AccessMonster.com]

Yikes! What have I started here?

Marshall, everything is fine. I looked at the code and I knew what you meant.

Here's my code:

stDocName = "Current Membership Report"
DoCmd.OpenReport stDocName, ac Preview
DoCmd.Maximize

It works like a charm.

Thanks so much,
Uschi

Uschi,

I did made an Oops, the TEXT and NUMERIC should be reversed. I guess both
Marshall and I need more coffee!

Uschi,

[quoted text clipped - 27 lines]