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?
shrimpforkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
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?
0
Jeffrey CoachmanMIS LiasonCommented:
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 clarityscreenshot
0
shrimpforkAuthor Commented:
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.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jeffrey CoachmanMIS LiasonCommented:
< 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...
0
shrimpforkAuthor Commented:
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
0
Jeffrey CoachmanMIS LiasonCommented:
Then why not just grab an image of a truck from the web and us that?

this image works fine for me:
Truck18717218-truck-icon.jpg
0
shrimpforkAuthor Commented:
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.
0
Jeffrey CoachmanMIS LiasonCommented:
Looks like this in image in Reporta report:
0
Jeffrey CoachmanMIS LiasonCommented:
Then please post your Truck image here...
I'd like to try it in a sample db...
0
shrimpforkAuthor Commented:
In what format & size would you like the image?
(My goal is a crisp 0.5" x 0.5" image)
0
Jeffrey CoachmanMIS LiasonCommented:
original size, ....bmp (bitmap)
0
shrimpforkAuthor Commented:
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
0
Jeffrey CoachmanMIS LiasonCommented:
Is the bmp you posted the original size of the image...
If so, then that is too small.

Create a bigger image that needs to be "shrunk" in Access in order to be the size you need.

In other words, if you create a good small image in your graphics program, the very act of "saving" it as a non vector format will cause it to get "Blurry"
.jpegs are the worst, ...but this effects bitmaps too, but to a lesser extent.

So create this image *in your graphics program* to be about 1 inch by 1 inch (bigger would be better)
This way when you save it as a bitmap, It may still be a bit blurry, However, when it is "shrunk" down to .25, in Access, it will look crisp.

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shrimpforkAuthor Commented:
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.
0
Jeffrey CoachmanMIS LiasonCommented:
In general, I create my images at least twice the size that I need them for this reason.

I set them all up as square, then all I need to do is make a square image control in Access, Then I always st the size mode to "stretch", so it fills the avialible space in the Access control.
And since the Access box and the image are both squares, I don't need to worry about size distortions.

<was shooting for creating an image at the printed size.>
this is the issue with converting to a non vector output, ...the inevitable blurriness will be more pronounced at the same size or bigger...

Note that most "images" now a days are fairly large, so scaling them down is always required, so then tend to still look OK.

There are exceptions, of course, ...but generally try to make your images (for this purpose) bigger than you actually need them.

Let me know

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
shrimpforkAuthor Commented:
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
0
Jeffrey CoachmanMIS LiasonCommented:
Great looking output, keep up the great work..
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.