I would prefer not to change the Access program instead change the DPI. What value should i change it to?
Main Topics
Browse All Topics
Loading Advertisement...
Question
page display 22"
Hi Experts,
I'm very confuse with how display actually work. Our office has 17" monitors and when we do print preview the report in Access appear fine however after upgrading the monitors to 22" the reports now come up with #### for some of the values. I've change them back to 17" and it works. How can the monitor affect the display. Even when i print the hashes come up.
I've tried installing the monitor driver and updating the graphics driver. What else do i need to do?
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
- "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
- "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
- "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.
See what Experts Exchange can do for you.
Got a question?
We've got the answer.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
Need individual assistance?
Our experts are ready to help.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Want to learn from the best?
Read articles from industry experts.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Working on a long term project?
Store your work and research.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Trusted by the world's most respected brands.
Faithfully serving IT professionals since 1996.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Free Tech Articles
-
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
-
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
-
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
-
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
-
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
-
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...
Cloud Class Webinars
- Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
- Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
- IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
- Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
- Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
- How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Answers
I'm afraid I can't answer that. In my experience with older versions of Access, it was best to leave the DPI setting at the (old) default value of 96. Anything else would mess up forms. Anyway, if you display a report with a small zoom factor (anything below 75%) and/or if you use small fonts (anything below 8pt), and if your text fields are narrow, you will get this behaviour.
The same happens in Excel: use auto-fit on number columns, and print preview a full page. By playing with the window size, you can trigger the ### display quite easily.
If you really need to avoid this, you will need to add internal white space in the text fields (or the Excel columns), there is no other way.
On the other hand, it's just a preview. If the user needs to read the value, he/she will have to print the report or view it in 100% zoom.
(°v°)
What printer are you using? My understanding is that Access builds reports based on the printer associated with that report (or the Default printer on the machine), so changing the printer could somewhat affect the way Access prints the report. I know that changing printers can trigger margin alerts and other anomalies, so perhaps this is in the same area as that. Try changing the default printer on one of the 22" machines and see if that clears things up.
What font are you using? Have you tried a different font?
Have you fully updated Windows and Office? Make 100% sure of this ...
<I would prefer not to change the Access program instead change the DPI>
If by this you mean you want to alter settings on the enduser machine in order for your application to run correctly, then I'd strongly encourage you to NOT do this. If you wish to require a particular environment (i.e. WinXP SP3 only, or 19" monitors only) then that's fine, but don't expect end users to tweak their machine settings in order to get your app to run correctly. Your application should conform to whatever settings are current on the machine.
We use the same printers for the 17" as well as the 22". We using the HP 5200 printers with Postscript.
It is just really weird. The minute you put in the 22" monitors the report shows differently. All the computers are up to date and our monitor that we bought is LG2242t. I've got several people complain about it already.
What do i have to change in Access for this to work? Auto FIt?
Autofit doesn't work well in Excel (it's what causes the problem most of the times). Instead, you should make more room:
|12'500.00| (remove a few pixel)
|######|
| 12'500.00| (remove a few pixel)
| 12'500.00|
Often, spacing is created outside the text boxes, it's better to use it inside:
|27'800.00| |12'500.00|
| 27'800.00|| 12'500.00|
I still don't understand the cause of the problem, though. Perhaps the 17" have a 1680x1024 resolution and the new 22" have only 1024x768 (so they are in fact logically "smaller"). Perhaps they are "plug and play" to such an extent that the DPI setting is changed when installing them?
But putting more space in your reports is never a bad idea, for stability, readability, and plain typographical aesthetics.
(°v°)
For reports, there is nothing much you can do, except let the users access window size and zoom factor. You design for the printed page; it's up to them to manipulate the screen preview.
For reports, it's much more complicated. I have built one application where the user could select the default font, from 8pt to 16pt, and every form would resize and redraw upon opening. Quite too complex and unstable to be published, though.
There are some tools around with fancy names like "shrinker stretcher" that resizes forms to fit the current window, but I find they create a very unprofessional look and feel.
It's always been a problem with Access (and many other platforms): it's easy to develop for one screen size, but not for varying screen sizes. This is one of the reasons Web interfaces have become so popular...
(°v°)
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer
Loading Advertisement...
by: harfangPosted on 2009-10-30 at 04:06:15ID: 25701744
Changing the screen size or the screen resolution doesn't affect the layout mechanism. However, changing the DPI value does (in [Display Settings], [Advanced]).
The DPI setting -- dots per inch -- determine how many pixels will be used to display on screen, say the number '2', size 10, 80% zoom. If it's very small, the closest match will be used from special small fonts, if it's just small, the most readable font for small sizes will be used. In other words, keeping everything else the same, changing the DPI value will force the report to use another "close match".
For numbers in small zoom settings, '1' will be narrower than '2', so you can perhaps see the value 112 in one row, but not 543 in the next...
A missing pixel in a text box is enough to cause "###" to appear (better that than showing 500 instead of 1500, isn't it? Bottom line: don't crowd your text boxes, leave enough margin for these variations.
(°v°)