Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Different sizes control elements. Why?

Status
Not open for further replies.

BrianWen

Programmer
Jun 8, 2009
102
DK
We are using a database in Access 2013, but the original file was created in perhaps Access 2000. It was later upgraded to ACCDB and actually the version the users use is ACCDE. Anyway, the original file got a bit corrupt (I couldn't delete things like queries and such and other strange behaviors). So after reading about the problem I made a new file (in Access 2013) and copied all forms, reports and all over in the new file. Suddenly control elements like buttons looked much different. I've learned that was because "Use Windows-themed Controls on Forms" was ticked in the new one, but not the old.

So now the new works and looks just the old one...for me and most others. However I have a lot of users complaining about dates becoming ### (not enough space in text boxes) and I can see some labels are way too small for it's text suddenly. It's the same fonts of course, same size (fontsize 8), I haven't changed anything, but I have confirmed it's the same in properties on the form in the new database and the old.

As mentioned it displays perfectly on my own computer. I can change my screen resolution and also the Display font size thingy in Windows to both 100% and 125%, doesn't change a thing. A user with the problem, with whom I've been testing, has the problem no matter Display size or resolution.

What is it I'm overseeing? :(
 
If he or she is the only one having that problem, check to see if he or she is using the same exact database.
 
This kind of thing can appear when the font set during development isn't available on the errant machine; when this occurs Access uses a different, arbitrary font, and some fonts are larger than others, so FontX set to a size of 8 may take up more space than FontY set to 8.

This usually happens when a developer tries to get fancy and use a font different from the default font normally used in Access, but it can merely be a case of the standard, default font having been deleted from the errant machine.

If the problem were only confined to Datasheet View Forms, it could just be a case where the Font/Size Options have been changed. These options on Datasheet Forms are controlled by how the particular installation of Access is set up, not by how it was set up on the development machine.

Linq ;0)>

The Missinglinq

Richmond, Virginia

The Devil's in the Details!
 
Thanks for the answers and sorry for the very late reply (Holiday).
It is the exact same database that is distributed out to about 100 users.
The font used in a least some of the labels with the problem, is MS Sans Serif (size 8) so it's a font everybody should have, but come to think of it, it's not a TrueType font. Could that be some of the explanation? Let me just point out it's MS Sans Serif size 8 in both the original (where it's the same, good, size for everyone, and the new one, where some have the size problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top