Solved

Insert image - wrong size

Posted on 2006-11-27
12
256 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

770 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