Opening report in design mode

[Jeff]

I have a need to open a report in design mode immediately before opening it
in preview, to change the Minimum and Maximum scale on an axis on a chart.

This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff

[Allen Browne]

Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...

I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart.

This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff

[Jeff]

Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...

I have a need to open a report in design mode immediately before opening

it

in preview, to change the Minimum and Maximum scale on an axis on a chart.
This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff

[Allen Browne]

Darn: should have been acHidden, of course.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jeff" <je************@asken.com.au> wrote in message
news:sn******************@news.optus.net.au...

Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...

I have a need to open a report in design mode immediately before

opening

it

in preview, to change the Minimum and Maximum scale on an axis on a

chart.
This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff

[Jeff]

That wasn't the problem. It said the named argument was incorrect. To my
knowledge there is no such argument to opening a report! Is there?

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

Darn: should have been acHidden, of course.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jeff" <je************@asken.com.au> wrote in message
news:sn******************@news.optus.net.au...

Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...
> I have a need to open a report in design mode immediately before opening it
> in preview, to change the Minimum and Maximum scale on an axis on a

chart.

>
> This results in a flash of the report in design mode just before it is > opened in preview mode.
>
> Is there any way to open it in design mode hidden?
>
> Jeff