Solved

Access report picture hidden lines

Posted on 2013-01-29
13
350 Views
Last Modified: 2013-02-12
Hi Experts,

I have inserted a picture in a report.

When i open the report in prwview mode zoom 100% it looks like picture "without line"

But if i zoom or create the report as PDF it looks like the picture "With line".

Why does it happen and how can i fix it. If i open the picture file and zoom there is no line.

The picture type is EMF. For some reason this give the best quality in the report.
without-line.JPG
with-line.JPG
0
Comment
Question by:DCRAPACCESS
  • 7
  • 4
  • 2
13 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 38833466
Unfortunately, it is a stupid feature of many report previewers (not only Access). The usual remedy here is to make the line "bolder". Even though, the previewer may decide to not draw lines in some cases
0
 

Author Comment

by:DCRAPACCESS
ID: 38834090
No the issue is that there should not be any lines :-(

I have made the border transparent, so it should only show the picture, nothing else.
0
 
LVL 24

Expert Comment

by:chaau
ID: 38834638
OK, I see. The line can be of the detail band or the header (if you put it there). Can you check its properties. As I said, you may not see it in the previewer by default. Try setting bigger zoom in the previewer, the line might be there as well
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38857234
<But if i zoom or create the report as PDF it looks like the picture "With line".>
This is an issue with how a your PDF converter will interpret the Access properties.
(It knows there is a always some sort of border, and it just draws it)

Can you state how you are creating the PDF and what version of Access you are using?

<border transparent>
Lets be clear...
There is a "BorderColor" Property, ...set this to: White
There is also a "BorderStyle" property, ...set this to: Transparent
Also make sure the "Special Effect" property is set to: Flat

JeffCoachman
0
 

Author Comment

by:DCRAPACCESS
ID: 38858251
Access 2007 and i'm using lebans reporttopdf
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38859873
With Access 2007 you can Download the free PDF converter
http://www.microsoft.com/en-us/download/details.aspx?id=9943
I use this for Access 2007 and newer with no "border" issues on PDF's
Report Image zoomed 200%, no border
I only use the Lebans utility for Access 2003 and older.
But to be sure, did you set all the properties I mentioned in my previous post? (in addition, please set the Border width property to "Hairline")

Finally make sure you are using a current version of your PDF "Viewer"
I only trust the Adobe free reader (or the full version) for viewing PDFs.

JeffCoachman
0
 

Author Comment

by:DCRAPACCESS
ID: 38863579
Sorry can't use the build in PDF creator, it has trouble making line charts. The quality is really bad. I have a old post about this problem and I have talked with one from microsoft support, and they don't support the PDF converter, it is something Adobe has made for them. That is why i have used Lebans. It is fast and the quality is good.
0
 

Accepted Solution

by:
DCRAPACCESS earned 0 total points
ID: 38863629
All the borders are correct. I have "fixed" by making a white thin box on top of the picture on each side, to hide the lines. But i don't like that solution even though it works.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38864115
<Sorry can't use the build in PDF creator, it has trouble making line charts. The quality is really bad.>
I have been using the PDF Add-in since it was first available, and never had these issues...

I am glad you got this fixed on your own.

You can now select you own post as the solution.
;-)

Jeff
0
 

Author Comment

by:DCRAPACCESS
ID: 38864874
Look at my old post:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24545766.html

The bad one is made with access add-in.

The other one is made with Lebans
0
 

Author Comment

by:DCRAPACCESS
ID: 38864887
Sorry not Lebans, Adobe Pro. But the result was the same. The line in the chart was not a clean line. And Microsoft Support tested it, and told me that it was not their problem, the add-in at I said is made by Adobe.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865007
ok
0
 

Author Closing Comment

by:DCRAPACCESS
ID: 38879494
Not the best solution, but the best one i could find.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 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