Preview / Design

[p_wikstedt]

I've encountered a few problems in doing reports: 1st, is it possible to set a fixed preview zoom somehow (in my case, "Fit") when previewing the report, and 2nd, how do I get the design-mode of the report updated after changes- it's pretty hard to make changes/modifications when I don't have the same content that I have in previewing or eventually printing out the report ??

 

[llkhoutx]

1st, you the "docmd.RunCommand acCmdSizeToFit" command.

2nd, use "docmd.Close acReport,,acSaveYes" command.

Both, with the quotation marks.

 

[p_wikstedt]

Still in trouble ..

Still being quite a novice with Access, I really don't know where exactly to put the suggested command lines and how to get there. In case I was in the right place, I however got an error saying somethin like "Sizetofit isn't available now". Furthermore I had to leave the quotation marks out for Access to identify the command at all...

 

[Pat Hartman]

it's pretty hard to make changes/modifications when I don't have the same content that I have in previewing or eventually printing out the report

Why are you making design changes from VBA at runtime?

 

[p_wikstedt]

My report is based on a form that runs a query, after which I get the data displayed correctly on the report preview. However, when going back to the design-view of the report the view is different from what I had on the preview. Thus, I'm trying to set a command in VBA that would always update the design-view of the report so that I can change markers and add trendlines etc...