473,387 Members | 2,436 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

zoom access report automatically

25
Hi,
I'm using access 2003. Is there a way for me to open an access report with zoom to 82% automatically? Right now, I set it up as maximize, using
Expand|Select|Wrap|Line Numbers
  1.  docmd.maximize 
but I want it to zoom to 82% for users to be able to see all the data clearly when they open the report.
Please help.

Thank you in advance.
Jun 30 '09 #1
3 7661
ADezii
8,834 Expert 8TB
@Bay0519
Is 75% close enough?
  1. In the Open() Event of your Report, place the following code:
    Expand|Select|Wrap|Line Numbers
    1. Private Sub Report_Open(Cancel As Integer)
    2.   DoCmd.Maximize
    3. End Sub
  2. To Zoom the Invoice Report to 75%:
    Expand|Select|Wrap|Line Numbers
    1. DoCmd.OpenReport "Invoice", acViewPreview
    2. DoCmd.RunCommand acCmdZoom75
Jul 1 '09 #2
Bay0519
25
Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...
Jul 1 '09 #3
ADezii
8,834 Expert 8TB
@Bay0519
You are quite welcome.
Jul 1 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: mar10a | last post by:
I am trying to insert a .gif. file into an Access report - using Insert Picture. The original image is 8X11, but access changes the size to 4X6.5. When I change the size of the image in access...
1
by: Elle Short via .NET 247 | last post by:
Hello All, any help would be appreciated: I am trying to pass a parameter to an Access Report. Just runningthe report from .net with no parameter in my access query and nowherecondition clause in...
0
by: neoteny2 | last post by:
I need MS Access to automatically create reports/subreports based on specific criteria. I am building a database in Access 2003 with different locations/sites. I have the "sites" table created...
1
by: ellenh | last post by:
I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display...
1
by: sbuelter | last post by:
Hello, I am building an access report that is essentially a form letter that I will automatically fax to the recipient when a button is clicked on a form. I have the form, faxing issues totally...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
2
by: Composer | last post by:
This is not a question but rather an answer, or at least a clue. Like others, I had experienced seemingly random truncation of text when exporting a perfectly good Access report to RTF. Or...
6
by: ncsthbell | last post by:
Hello, Wanted to ask the best approach to handle this situation: My users want to be able to go into an access application, press a button and it run a report and the report automatically run and...
1
by: billelev | last post by:
Here is some code that I have adapted slightly. It allows a report to be printed to a specific location. It works by calling SaveReportAsPDF and specifying the access report name, and the root...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.