Solved

Images display as thumbnails when Size Mode is set to Clip

Posted on 2008-10-24
11
294 Views
Last Modified: 2013-11-28
One computer (out of the hundreds running the same database) is displaying all images that are included on reports (size mode set to clip) as thumbnails.

The setup is pretty basic: Reports that need to print onto a pre-arranged form have the form scanned into the computer and set as their background, so the the report can just fill in the appropriate information and print the completed form out.

Apparently, something is causing this computer to improperly render images in Access.  The image displays properly outside of Access, and also displays properly when set to zoom or stretch from within Access.  Any idea what could be causing this?

proper.jpg
incorrect.jpg
0
Comment
Question by:cgmyesco
[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
  • 6
  • 5
11 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22801004
cgmyesco,

1. You listed 3 versons of Office.
What version is the faulty computer running?

Could be many things:
Outdated Video Drivers
Wrong Video Drivers
Windows "Video" settings (XP style versus Clasic style, )
Screen resolution
Refresh Rate
Color depth
Apperance "Effects"

So, the first thing you shoud do is download and install all the latest:
Updated Video Drivers
Service Packs for Windows *and* office.

JeffCoachman
0
 

Author Comment

by:cgmyesco
ID: 22980130
The problem occurs on:
Access 2000 SR-1
Access 2002/XP with SP3
Access 2003 Runtime (with or without SP3)
Access 2007 Runtime (with or without SP1)

And now the problem is occuring in 2 seperate offices at 2 completely different businesses.

I have ruled out video drivers being the problem at both locations.   I have ruled out windows and office updates at 1 location.  I will bring the other location up to date to see if it helps, but I have a feeling that it will not.

Screen resolution and color-depth should not be a factor.  Access Reports scale based on the selected printer, paper size, and page setup settings.

The text and general layout of the report scale properly, but the background image is getting shrunk down to thumbnail size (for whatever reason) only on these 2 trouble machines.

I think we can also safely rule out refresh rate, as the problem occurs not only when viewing the report on-screen, but also when printing it.

Any additional ideas?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22982101
cgmyesco,

    "Any additional ideas?"
What happens if you simply recreate the report?

If it displays correctly with the size mode as "Stretch" then why not just size it correctly in that mode and leave it?

JeffCoachman
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cgmyesco
ID: 22985212
I have around 2,000 reports that would need to be modified if I switched to stretch.  The images would have to be resized, cropped, and the positioning of the fields on the reports would need to be adjusted.  There's no way I could bill anyone for this, so I'd really rather SOLVE the problem instead of working around it.

Clip has worked for years, and continues to work on 99% of computers.

As far as recreating the report:  The 2 problem computers don't just exhibit this behavior on 1 report, it is for ALL reports that utilize a background image.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22989337
OK

OK, then on these two computers, can you try another image type?
Bitmap(bmp), Jpeg(jpg) and Graphics Interchange Format (gif) are all valid.

It may be that the file associations for some file types may not be set correctly for these computers.

JeffCoachman
0
 

Author Comment

by:cgmyesco
ID: 22989740
I have made further progress in narrowing down the problem: It only occurs when Office 2007 or Access 2007 runtime are installed or have been installed and removed.

On the 2 problem computers the users had installed Office 2007 Basic on top of their existing office installations, and later removed it.

I was able to reproduce the problem on my computer by installing Access 2007 runtime on top of an existing Office 2003 installation.

This appears to be a problem specific to Office 2007.  I am trying to dig up an Office 2007 CD to install.   I will do additional research and report back with my findings.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22991341
Great,

Some hints:
Install SP1 for Office 2007 *And* the subsequent Hotfixes.
(Most people wrongly assume that installing SP1 is all they need)
;-)

Good luck and keep me posted

JeffCoachman
0
 

Author Comment

by:cgmyesco
ID: 22994859
The results are in: Images must be approximately 10 times larger to be displayed at the same size when upgrading from a previous version to Office 2007.

The clip size mode still works properly, but the scaling is different from previous versions.  Microsoft must have done this to allow for more hi-res background images to be used on reports.

Unfortunately this breaks my functionality and I have to revamp all of my reports.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22995513
cgmyesco,

"10 times larger"
In terms of what?

Image Dimensions?
Image Resolution?
Image Byte Size?

JeffCoachman
0
 

Accepted Solution

by:
cgmyesco earned 0 total points
ID: 23017414
Dimensions.

Pre-Office 2007, an image that is 600x772 would fill up 1 entire page when size mode is set to clip.

In Office 2007, I don't have the exact dimensions yet, but you need something closer to 4704x6128 to fill 1 entire page with size mode set to clip.

It seems MS has changed the way they size/scale images and has opted for a more hi-res approach than in previous versions.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23018213
OK
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

696 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