473,396 Members | 1,799 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,396 software developers and data experts.

Report in 100 Zoom

29
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!
Sep 3 '06 #1
3 3897
MMcCarthy
14,534 Expert Mod 8TB
Put the following line of code after the Report Open command

DoCmd.RunCommand acCmdZoom100

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!
Sep 4 '06 #2
rgsw
29
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
Sep 4 '06 #3
rgsw
29
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.
Sep 4 '06 #4

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

Similar topics

1
by: Alex Stevens | last post by:
Hi All, I have implemented my own toolbar on a form which houses the crystal reprot viewer. I would like to have a combobox to allow the user to change the zoom level to say 25 / 50 / 75 / 100...
2
by: Majstor | last post by:
How to open report in specific zoom? Any suggestions? Mario.
7
by: Susan Bricker | last post by:
I would like to generate a report (I have the report working already) using MS/ACCESS 2000 and then have the ability to send the report as an email attachment to my colleagues. I have looked...
5
by: MS | last post by:
I want to "maximise", then fit a report into the available window. ATM I maximise on the OnOpen event, then use send keys ...... %{v}, %{z} ....to zoom and fit to the window. Is there a...
2
by: Marie | last post by:
When a report is open in preview mode, you can go to the Zoom button on the toolbar at the top of the screen, type in a zoom percent different from what is in the list and the magnification changes...
3
by: Heather | last post by:
What is the report function in Access 97 that allows you to zoom to a specific size? ie.125% Not the Minimize or Maximize function.
1
by: ajaymehra | last post by:
Hi, Im trying to create a "MS Project > Resource Usage" type o application report. The manager will see his resources work hour distributed along a default time period (say 1 month). He then has...
7
by: PW | last post by:
Hi, I'd like to add a picture in a report where the path to the picture is from a table, depending on the dogid that is on the report (in the detail section). How can I do this? Thanks!
3
by: Bay0519 | last post by:
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 docmd.maximize but I want it to zoom to 82%...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.