Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Very Strange problem while trying to preview reports in ADP file.

Hello,
         I am having an issue while previewing reports in an ADP I'm developing. Whenever I try to preview a report I get this very large font zoomed in version of the report. Its almost like I would have to print it out and piece it together like a puzzle to read it. Even when I export it to Microsoft word I still get the same issue. Microsoft Word even says the font size is 12. When I select all and change it to 12 (even though it already says its 12) the font gets very very small and is still all on separate pages. The only way that I can view my changes is to package the ADP and install it onto my computer and then run the report. This is not a very efficient way to make reports. I am extremely frustrated any suggestions or ideas are greatly appreciated
0
GeneralDigitalITS
Asked:
GeneralDigitalITS
  • 6
  • 3
  • 2
1 Solution
 
GeneralDigitalITSAuthor Commented:
0
 
IrogSintaCommented:
That is strange indeed.  Can you try experimenting with the zoom levels in the report's Open event just to see what it does?

DoCmd.RunCommand acCmdZoom10
or
DoCmd.RunCommand acCmdZoom25
0
 
GeneralDigitalITSAuthor Commented:
Thanks for your comment. Here is the error I get when I try the zoom command. Also during the print preview when I use the zoom is just makes the page look really far away, doesn't effect the font.
Capture.PNG
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanMIS LiasonCommented:
Basic questions:
1. Is this for all reports or just this one?
(Have you tried simply recreating it?)

2. Is this for all machines, or just one?

3. All service Packs installed for Office and Windows?

4. I guess you know already, but ADPs have been deprecated since Access 2007, so there is no implicit or explicit support for them by MS.
Subsequent updates may case issue with ADPs, that may not be easy to resolve.

5. Are you compiling the code and compacting the DB on a regular basis?
6. Have you tried creating a new DB and importing all the objects?
0
 
GeneralDigitalITSAuthor Commented:
Greetings boag.

1. All reports.

2. It happens on the my computer with Windows 7. I also have a Virtual machine running XP that exhibits the same behavior.

3. All service packs are installed.

4. I am aware of this. Unfortunately, I don't think anything other than an ADP is an option at this time.

5. I do compact and repair daily. I compile the ADP each time I package a new version(which has been at least once a week lately).

6. I have recently been unable to build new databases from Source safe. I suspect that the issues are related. Source safe will import most of the items, then fails towards the end with some network connectivity issue. There is definitely no loss in connectivity so I'm not sure what that is about. I can click through each of the items that failed and then it asks my to save changes to a bunch of forms, which doesn't really make any sense because I haven't changed anything on those forms, I just imported them.

I don't really know what to do. should I start rolling back updates?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Basically, I have never heard of this issue...

So something is definitely going on there...


If you create a new totally new/unrelated ADP,  is this still an issue?
0
 
GeneralDigitalITSAuthor Commented:
I will try that. Just wondering, What options do I have other then ADP format? are there ways to convert or upgrade to a newer format?
0
 
GeneralDigitalITSAuthor Commented:
I just found at the the problem goes away if I change the default view property to report view. It at least allows me to work around the issue. I didn't know if that signified anything to anyone.
0
 
GeneralDigitalITSAuthor Commented:
SOLVED! Turns out the Print preview mode formats the report for your default printer. For some odd reason my default printer was a Zebra label printer!!!! Thanks for the participation guys.
0
 
IrogSintaCommented:
That makes sense. I'm glad you figured it out.
0
 
Jeffrey CoachmanMIS LiasonCommented:
GeneralDigitalITS.

Then according to you, ...you solved your own question.

Pleas click the "request attention" link and ask that my post be unaccepted, and your post be Accepted.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 6
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now