Text box / cell padding

  • Thread starter Thread starter Randy K.
  • Start date Start date
R

Randy K.

I have 2 text boxes on a datasheet view subform that are both .25" wide. I
have the font set as Tahoma 8pt. When this form is open, I have extra white
space to the right of letters and to the left of numbers so I try and shrink
them down to the smallest size that will display a W. I can't get rid of
all the extra white space, it just starts chopping of the actual letter
first.

Also, to relate back to the 2 boxes mentioned in the beginning. The first
box never displayed a W until recently, but the 2nd box has for awhile so I
set both boxes to the .25 as that was what was needed to get the W to
display correctly in the 2nd box. Now that I have a W in the first box, it
is getting cut off on the right hand up stroke. But the 2nd box still is
displaying the entire W. I check the properties and both boxes are exact
same size, font, border, alignment.

Any idea why the 2 boxes don't behave the same way and how to reduce the
needed size to display a given character.

Access 2k on Win2k.

TIA,
Randy
 
Randy

From your description, you are dynamically changing the dimensions of your
controls' widths. Doesn't that make it more difficult for the users to know
where to look for information?

Another suggestion would be to format the controls to "center" their value.
This would have the added benefit of not needing to continually adjust the
width.

JOPO (just one person's opinion)

Jeff Boyce
<Access MVP>
 
No, the sizes are static, just trying to find the 'right' initial size to
display a W (The widest letter that would occupy the box). The problem is,
a W gets cut off, but there is still plenty of space to the right of the
letter. I have tried center justification and it does the same thing.
 
Ah, by "extra white space" do you mean you are storing spaces as well as
visible characters? Is this what you meant by "cell padding"? Does your
underlying table hold "W" or " W "?

Check Access HELP on the Trim() function, if the latter.
 
Back
Top