Solved

Images display as thumbnails when Size Mode is set to Clip

Posted on 2008-10-24
11
288 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
  • 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
 

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server views 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 Access…
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…

911 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

24 Experts available now in Live!

Get 1:1 Help Now