Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > access > answers

Report in 100 Zoom

Newbie
  
Join Date: Jul 2006
Posts: 29
#1: Sep 4 '06
Hi - I'm trying to figured out how to click on a report and have it already in 100% zoom instead of having always click on zoom to make report larger. Thanks!

msquared's Avatar
Administrator
  
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,885
#2: Sep 4 '06

re: Report in 100 Zoom

Put the following line of code after the Report Open command

DoCmd.RunCommand acCmdZoom100

Quote:

Originally Posted by rgsw

Hi - I'm trying to figured out how to click on a report and have it already in 100% zoom instead of having always click on zoom to make report larger. Thanks!
Newbie
  
Join Date: Jul 2006
Posts: 29
#3: Sep 4 '06

re: Report in 100 Zoom

I converted the macro to VBA as shown below. Because I'm just learning VBA, I'm not sure where to insert the code you gave. Could you give an example. Thanks again!

DoCmd.OpenReport "Query2", acViewPreview, "", "", acNormal
Newbie
  
Join Date: Jul 2006
Posts: 29
#4: Sep 4 '06

re: Report in 100 Zoom

Quote:

Originally Posted by rgsw

I converted the macro to VBA as shown below. Because I'm just learning VBA, I'm not sure where to insert the code you gave. Could you give an example. Thanks again!

DoCmd.OpenReport "Query2", acViewPreview, "", "", acNormal

Never mind finally figured it out. Thanks this works.
Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved