Unbound object frame failing to display linked image at correct resolution

sakurako97

New member
Local time
Today, 01:06
Joined
May 19, 2013
Messages
4
Hi,
First time post...here goes...
I am using an unbound object frame to display an .png image file which is set in vba.
The image is an excel chart saved as a .png
The problem I have however is that the image I save from Excel is great quality, and is pretty tack sharp, but when I display the same file in the unbound object frame in access, it is not nearly as sharp.
I am setting the picture property of the control as:

ubImageUserChart = "c:\temp\myChart.png"

It displays alright, but is just a bit fuzzy - still quite legible, but it is a complex graph with a lot going on - has regressions and formulas etc on the graph, and they need to be very clear.

Has anyone else come across this?
BTW - the unbound frame is the same size as the Excel chart which gets saved as a .png file. If I tile the images (Access unbound frame and original file in picassa preview) side by side - they are identical - size, orientation etc.
Just one lacks sharpness.
Any ideas would be much appreciated.:banghead:

p.s it is not practical for me to try and do the chart natively in access as it is way to complex. I am using access vba to drive an excel session to do all the statistical yack work and chart rendering, then displaying a png image of the resulting chart in an unbound object frame in access.
 
Have you tried playing around with the different Size Modes for your unbound frame?
 
Hi,
Thanks for your reply!
Yes, I have tried all sorts of shapes and sizes to see if it changes anything, but it is always slightly hazy.
I know the image file is good as I can see it clearly in any image viewing program.
Anyway, will keep playing around with it and see where it gets me.
Thanks
 
Only a thought, can't you not use a bound object frame linked to the graph in the Excel spreadsheet?
 
Just for clarification, by Size Mode I meant Zoom, Clip, Stretch in the properties sheet, not the physical box height and width.
 
Thanks billmeye, your a saviour!!
I have never even noticed those options b4.
I had it originally set on zoom - made no diff on stretch, but when i set it to clip, bango, it cleared up.
It's not quite the same as the original, but it is sure good enough for the report.
Once again, thank you for your help.:D
 
Your welcome. Access native storage is BMP so it might be doing a conversion from PNG to BMP creating some loss of quality. You might try saving your Excel as BMP and see if it looks any better.
 

Users who are viewing this thread

Back
Top Bottom