Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access report picture hidden lines

Posted on 2013-01-29
13
Medium Priority
?
359 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 25

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 25

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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

879 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