Link to home
Start Free TrialLog in
Avatar of GeneralDigitalITS
GeneralDigitalITS

asked on

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
Avatar of GeneralDigitalITS
GeneralDigitalITS

ASKER

Avatar of IrogSinta
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
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
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?
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?
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?
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?
ASKER CERTIFIED SOLUTION
Avatar of GeneralDigitalITS
GeneralDigitalITS

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
That makes sense. I'm glad you figured it out.
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.