Solved

MS Access 2003 Reports - left side of page is cut off on printing

Posted on 2010-09-08
5
387 Views
Last Modified: 2012-08-13
I have a number of reports in MS Access 2003 report writer that work fine. I've modified a few of them to use an onFormat event which adds colored banding to the report. Now when I print the report the left side of the page is cut off, its like the page has shifted to the left. This is on a landscape report. I can set the border on the left to be an inch and then it will print on the page, but this was not necessary before. I've been through every setting, comparing it with other reports, and I cannot see any difference.

Does anyone have an idea how to uniformly set the x/y coordinates for a report like this...I'm not asking for anything special, just for the report to print on a normal piece of paper.

TIA
Ron
0
Comment
Question by:KnowledgeWare
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 33634166
First things first.

Does this report work OK without the "colored banding"?
Do these other reports also have the color banding, but display OK?

Sometimes the report gets corrupted and needs to be recreated from scratch...

And just to be clear, ...when you say:
"I have a number of reports in MS Access 2003 report writer that work fine."
Are you meaning to say:
<I have a number of reports in MS Access 2003 that work fine.>

(Or do you actually have some External Report writer)


Screenshots and/or sample files are always helpful for troubleshooting issues like this.
Can you post a sample of your database that displays this issue?

Sample database notes:
Back up your database(s).
Combine the front and back ends into one database file.
Remove any startup options, unless they are relevant to the issue.
Delete any objects that do not relate directly to the issue.
Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
Compile the code. (From the database window, click: Debug-->Compile)
Run the compact/Repair utility.
Remove any Passwords and/or security.
Post explicit steps to replicate the issue.
Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue.

;-)

JeffCoachman




0
 

Author Comment

by:KnowledgeWare
ID: 33648993
Thanks Jeff for these suggestions. Let me try some and I will reply.
0
 

Author Comment

by:KnowledgeWare
ID: 33756894
Thanks! I"m not sure exactly which suggestion did it but somehow I have the reports printing properly now.
0
 

Author Closing Comment

by:KnowledgeWare
ID: 33756896
Thanks, not sure which one did it but they are now centering.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33758448
<but they are now centering.>
Then tat is all that matters...
;-)

Enjoy the weekend.

Jeff
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Direct Mail software 4 42
Run Time Error 3075 15 43
Cross Tab with two column values 7 32
Getting the Error "User-defined type not defined" in MS Access 2013 16 40
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now