Solved

Insert image - wrong size

Posted on 2006-11-27
12
255 Views
Last Modified: 2008-02-01
I have been sent a logo which I have inserted into our Word templates. When inserted it is about a quarter of the size it is when viewed in windows explorer, paint etc. This is great as it is actually the size we need and the text remains readable.
Now when Insert this same image into our access reports it is the larger size (not good). If I resize the image in a graphics program the text becomes unreadable.

What makes Word resize this image when inserted (dpi?) and how can I make the image behave the same in the Access report?
0
Comment
Question by:QPR
12 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 168 total points
ID: 18025843
Could u not resize the image your MS Access report?
0
 
LVL 39

Assisted Solution

by:stevbe
stevbe earned 166 total points
ID: 18028057
in your Access report make sure to use an image control and that the Size Mode property (on the format tab of the properties page) is set to Zoom ... now you should be able to resize it just like in Word ... click on it once and then grab a corner and make bigger / smaller as necessry. As Rocki posted you should not need to use a seperate image editor for this.

Steve
0
 
LVL 29

Author Comment

by:QPR
ID: 18039647
But any idea why it is a different size in Word than it is in Access?
It may all be dpis (that I don't really understand how apps handle this). If I open in an image editor it is around 400px square, when I insert into Access - same size. When I insert into Word it is 100px square (which is what I want). If I resize down to 100 square in the image program the text is blurry and it prints bad. In Word the properties show it as 200 dpi the image editor shows 72 dpi
0
 
LVL 39

Expert Comment

by:stevbe
ID: 18039796
The image control in Access is different than the one in Word ... to get a straight answer on why they made them different ... who knows ???
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18089781
<who knows ???>

stebe, QPR,

My only guess is that Word will let you do some very basic image editiing (Contrast, Brightness, cropping, transparency)
...while Access will not.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18089795
Another thought,

Although Access will display Gif's, Bmp's and Jpg's... it actually stores them internally as bmp files.
(This is why a 50k image file will bloat the database by about 200k)

Also the "Ole Server" that Access uses may effect this...

But I won't even go there!
:)

jeffc
0
 
LVL 39

Expert Comment

by:stevbe
ID: 18092337
jeff ... I was not asking what is different between Word and Access image handling , I was posting rhertorically ... why did M$ make Office and Access image handling different? :-)

as to the real issue at hand ... how to shrink the logo like you can in Word and add that to your Access reports ... you can size it in Word and then copy / paste it from Word onto your Access report (while in design mode), that creates a Word doc object on the report which you can then convert to a Word Picture object (right click, select document object convert).

Steve
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 18093613
Oh yeah Steve, I knew what you meant
;)

Yeah, I'm still wondering why moving columns "Looks" slightly different in Windows Explorer, Outlook, Project, and Excel!
:)

<If I resize down to 100 square in the image program the text is blurry and it prints bad>
..happend to me once as well. As soon as I got the image sized just right, we could not read the blurry text on the image.

arrrrrr!

:)

0
 
LVL 39

Expert Comment

by:stevbe
ID: 18093633
the company I work for has a logo with text that is set at an angle with text set horizontally beneath it ... how bad do you think that looks when it gets shrunk :-)

I have been trying to get them to have someone make us a nice pretty icon for a long time by it just does not seem to matter what I use for icons in my app so I use the full blown logo in my splash :-)
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 166 total points
ID: 18093872
OK, now you've both got me thinking...

Form what I know, Access uses an "OLE Server", which is basically the program Access uses to "render" the image
(Perhaps you could change it to a more rubust graphics program, with better rendering capabilities??)
:O

The first link below is general, the other two are quite interesting as they go into depth about how images are actually stored/displayed.

http://office.microsoft.com/en-us/access/HA011472041033.aspx

http://support.microsoft.com/kb/262437
http://support.microsoft.com/kb/123151

Happy reading and Good Luck!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now