Solved

Insert image - wrong size

Posted on 2006-11-27
12
254 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

746 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

11 Experts available now in Live!

Get 1:1 Help Now