?
Solved

Insert image - wrong size

Posted on 2006-11-27
12
Medium Priority
?
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 65

Accepted Solution

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

Assisted Solution

by:stevbe
stevbe earned 664 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
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 664 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…
Suggested Courses

800 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