[Webinar] Streamline your web hosting managementRegister Today

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

Access report picture hidden lines

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
DCRAPACCESS
Asked:
DCRAPACCESS
  • 7
  • 4
  • 2
1 Solution
 
chaauCommented:
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
 
DCRAPACCESSAuthor Commented:
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
 
chaauCommented:
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jeffrey CoachmanMIS LiasonCommented:
<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
 
DCRAPACCESSAuthor Commented:
Access 2007 and i'm using lebans reporttopdf
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
DCRAPACCESSAuthor Commented:
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
 
DCRAPACCESSAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
<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
 
DCRAPACCESSAuthor Commented:
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
 
DCRAPACCESSAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
ok
0
 
DCRAPACCESSAuthor Commented:
Not the best solution, but the best one i could find.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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