Set Report Zoom to 90% - Microsoft Access / VBA

Marie

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 to whatever you typed in. When
I open a report in code, I would like to set the zoom to 90%
programatically . There are RunCommand acZoom constants for 75% and 100% but
no 90%. I tried using acZoom90 but get an error message. Can the zoom be set
programatically to 90%? How?

Thanks!

Marie

Nov 13 '05 #1

Subscribe Reply

6502

Richard Bernstein

ZoomControl may be undocumented, but its been working for me:

strRpt = "xyz"
docmd.openrepor t strRpt, acViewPreview
Reports(strRpt) .ZoomControl = ZOOMPERCENT

Where ZOOMPERCENT is a public constant declared in a module
Public Const ZOOMPERCENT As Integer = 90

Richard Bernstein
"Marie" <pl****@no.spam > wrote in
news:pf******** *********@newsr ead3.news.pas.e arthlink.net:

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 to
whatever you typed in. When I open a report in code, I would like to
set the zoom to 90% programatically . There are RunCommand acZoom
constants for 75% and 100% but no 90%. I tried using acZoom90 but get
an error message. Can the zoom be set programatically to 90%? How?

Thanks!

Marie

Nov 13 '05 #2

Allen Browne

That's cool, Richard.

Looks like it has to be set after the report is open, i.e. Report_Open and
Report_Activate are too early.

Setting ZoomControl to zero achieves a size-to-fit.

Setting ZoomControl to 1 generates an error:
There isn't enough free memory to update the display.
Close unneeded programs and try again
Maybe it's not completely reliable, hence undocumented.

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

"Richard Bernstein" <no@spam.com> wrote in message
news:Xn******** *************** ********@69.28. 186.158...

ZoomControl may be undocumented, but its been working for me:

strRpt = "xyz"
docmd.openrepor t strRpt, acViewPreview
Reports(strRpt) .ZoomControl = ZOOMPERCENT

Where ZOOMPERCENT is a public constant declared in a module
Public Const ZOOMPERCENT As Integer = 90

Richard Bernstein

Nov 13 '05 #3

Similar topics

1001

Change Crystal Report Zoom Level using percentages in Crystal Report Viewer (Dotnet)

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 / 200% However the crystal report viewer only seems to allow two levels of zoom, using the .Zoom method, 1 for actual size, and 2 for fit to screen. Is there any way that I can manually set the zoom level to something else

.NET Framework

1526

Report and zoom, help.

by: Majstor | last post by:

How to open report in specific zoom? Any suggestions? Mario.

Microsoft Access / VBA

16597

Sending a report (generated by MS/ACCESS) as an email attachment

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 around in the MS/ACCESS Help facility and found that I can click on FILE (on the Menu Bar) and then click on SEND TO. This will generate, either, a 'Snapshot format' or 'Rich Text Format' file and send an email. Two problems: 1. Is it possible to...

Microsoft Access / VBA

8678

Zoom and fit report to wimdow

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 better "non send keys" way to do this?

Microsoft Access / VBA

2851

Access 97 report function to zoom to a specific size?

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.

Microsoft Access / VBA

1104

Datagrid or Table Control for my crazy report ?

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 th option to zoom in or zoom out of this timescale. So, say he clicks o the "zoom in" button, the timescale should change from months to weeks If he clicks zoom in again - it should change to days. Zoom out will d the opposite. Of course, to...

ASP.NET

4052

Report in 100 Zoom

by: rgsw | last post by:

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!

Microsoft Access / VBA

1943

Pictures in a report? (A2K3)

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!

Microsoft Access / VBA

7692

zoom access report automatically

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% for users to be able to see all the data clearly when they open the report. Please help. Thank you in advance.

Microsoft Access / VBA

9596

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10614

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10363

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10369

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10109

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7649

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4327

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3847

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General