473,327 Members | 2,090 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,327 software developers and data experts.

Access 97 report function to zoom to a specific size?

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.

Nov 13 '05 #1
3 2825

"Heather" <HW******@cox.net> skrev i en meddelelse
news:11*********************@z14g2000cwz.googlegro ups.com...
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.


Look at this one.
http://groups.google.dk/groups?hl=da...ases.ms-access

Jan
Nov 13 '05 #2
Minimize and Maximize affect the window not the report itself.
You should be able to use RunCommand to do close to what you want.
Like ...

DoCmd.OpenReport strRptName, acViewPreview
DoCmd.RunCommand acCmdZoom150
DoCmd.Maximize

However, I don't believe 125% is available.

- Jim
On 8 Mar 2005 05:24:33 -0800, "Heather" <HW******@cox.net> wrote:
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.


Nov 13 '05 #3
On 8 Mar 2005 05:24:33 -0800, Heather wrote:
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.


If you open the report from an event, on a form for instance, you can
use:
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom150

You need to use a Zoom factor that is one of the RunCommand constants,
acCmdZoom10, 25, 50, 75, 100, 150, 200, 500, 1000
or acCmdFitToWindow, so Zoom125 is not available.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

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...
20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
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...
11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
1
by: Heather | last post by:
I am trying to open a report in my Access 97 database to open as view:125% for the default. Thank you in advance.
5
by: Ntl News Group | last post by:
I have a 97 database and want to embed (not link) a picture on a form and report The picture is just a scan of a signature, I am storing it in a table as an OLE object, then on a form I copy and...
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!
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.