Access 2007-Report opens by default in Print Preview mode

[Mike Turner]

My Uncle uses Access 2007 and has a database report which seems to open by
default in print preview mode.

The database was created using an earlier version of Access.He seems to
think that at one time the report did not open within Access 2007 in print
preview mode but in report view mode (am not sure of right phrase here) and
can't see why the behaviour has changed.

He just needs the report to open by default in report view mode(?) so he can
easily read it on screen.

1 What may have caused this change in behaviour,if indeed it has changed (am
just interested)?

2 More importantly,can this default behaviour be altered (eg by a setting
within Access 2007 or perhaps code within an "Open Report" event,if that
event exists?)

I'm a bit rusty on Access nowadays.At present I don't think there is any
coding in any report event that might cause the report to open in print
preview mode.

I don't have Access 2007 myself and would like to give my Uncle advice on
this or,if necessary, visit him and make the changes.

Many thanks for any help.

Mike Turner

[Allen Browne]

Open the report in design view.
Set these properties for the report:
Allow Report View Yes
Default View Report View

Chances are, one of those got altered.

If the report is being opened programmatically, specify the view:
DoCmd.OpenReport "Report1", acViewReport

General suggestions for your uncle re adapting to the new version:
http://allenbrowne.com/Access2007.html

--
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.

"Mike Turner" <MikeT...@discussions.microsoft.com> wrote in message
news:19804ED0-DCA5-4EBD...@microsoft.com...

[Mike Turner]

Thanks for your help Allen.

Mike Turner