Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Images display as thumbnails when Size Mode is set to Clip

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
cgmyesco
Asked:
cgmyesco
  • 6
  • 5
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
cgmyescoAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
cgmyescoAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
cgmyescoAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
cgmyescoAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
cgmyesco,

"10 times larger"
In terms of what?

Image Dimensions?
Image Resolution?
Image Byte Size?

JeffCoachman
0
 
cgmyescoAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
OK
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now