Link to home
Start Free TrialLog in
Avatar of shrimpfork
shrimpforkFlag for United States of America

asked on

MS Access Image Quality in Reports

I have been designing a report that shows the status of our product inventory.  I have an area on the report that simply displays the status of each item by displaying a simple symbol.  I have been able to use fonts in the wingdings font family for most of my conditions.  My problem is that I have created a custom graphic to represent the condition that something is "On Order", but this graphic is displayed with fuzzy edges.  It is not as clean as the MS font symbols because of the vector vs pixel imaging.

I understand the difference between vector art and pixel art and I know that the MS fonts are displayed and rendered as vector art.  I have created my image in adobe illustrator, but I cannot find a good format to show this custom symbol with crisp edges.  It just looks bad.  Any suggestions?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

What is the image type?  (.bmp, .jpg, .png, ...etc)
What is the file size of this image (the resolution, ..etc)
What type of control are you using to dis[play this image?
How, "exactly" are you displaying the image? (VBA, OLE, Attachment, ..Path Linking, ...etc)

Can you post a screenshot of this images at it appears in the report?
1. If the images are jpg or bmp (not sure about png...)
2. They are stored in a folder, (ex.: c:\YourFolder\YourImageOnOrderYes.jpg")
3. You use a standard image control on the form
4. You can use code like this on the Detail format event of the report to view the images
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.OnOrder = True Then
    Me.Image23.Picture = "c:\YourFolder\YourImage1.jpg"
Else
    Me.Image23.Picture = "c:\YourFolder\YourIamge2.jpg"
End If
   
End Sub


I have loaded up to 5mb jpgs with no loss in clarityUser generated image
Avatar of shrimpfork

ASKER

The image size is 0.5" x 0.5" when printed.   I can save it into any format.  I'm simply using the image control in the report and linking the image to the report. I've tried clipped vs zoom vs shrink to see if any produce a clean edge image.  When I get back to the office ill include some screenshots and upload the image file I am using.
< and linking the image to the report>
Not sure what this means...

..also see my other questions...

In my simple example above, this all works fine with 1 mb jpgs...
Ok Experts, I'm back in the office.  I have attached a screen shot image of a report that shows the difference between the vector art of the two arrows using a symbol in the MS fonts vs. the custom image of a truck that I made up with adobe illustrator.  You can see the image of the truck looks blurry, which is compounded when printed.

As to the linked image comment, I was referring to the settings of the IMAGE within the picture type setting.  I have this as a "linked" image, not "embedded".
I can save this truck image in any format.  I have tried JPG, PNG, TIFF.  They all produce a blurry edge.
You will not see this within a standard photo with many colors as you have demonstrated.  It has to do with a image with a crisp line.  As in a logo, or the image I am working with.
This is on a report, not a form.

(I have also included a PDF version of the icon, so you can see how clean the image should appear.)
Screen-Shot-Comparison1.jpg
On-Order.pdf
Then why not just grab an image of a truck from the web and us that?

this image works fine for me:
User generated image18717218-truck-icon.jpg
That is not really fixing the issue.  This also happens with our logo on the top of the page.  I'm just looking for a crisp clean line when I print a custom vector graphic.
Looks like this in User generated imagea report:
Then please post your Truck image here...
I'd like to try it in a sample db...
In what format & size would you like the image?
(My goal is a crisp 0.5" x 0.5" image)
original size, ....bmp (bitmap)
Here is the BMP format.  I have this sized so that is prints about 0.5" x 0.5" when the image Size Mode is set to "clipped".

You can see that details in the edges are very blurry because of the conversion to a pixel format at that size.  

I have also included the PDF vector art version of this image so you can see what I'm shooting for in the clarity.
On-Order.bmp
On-Order.pdf
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok, Jeff.  I was looking not to use the "zoom" setting for the size mode, and was shooting for creating an image at the printed size.  I will make a larger image and have access scale it down.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Your suggestion worked out good.  I even changed the icon from a truck to a Purchase Order to represent material that is "on order".

Thanks Jeff

(See attached report)
Extrusion-Inventory-Summary.pdf
Great looking output, keep up the great work..
;-)