Twips!?

[NewShoes]

Hey all,

I'm wanting to resize a form depending on whether or not a checkbox is checked (on the same form). I believe this can be done in VBA by using twips but I'm wondering if anyone could point me in the right direction please?

Many thanks,
-NS

 

[boblarson]

TWIPS are 1440 to an inch (not sure what that translates to in centimeters if you use that unit of measurement).

What I will do is figure out what I want for a size (in inches) and then just use that in my code. For example

Me.InsideWidth = 3 * 1440

which would be 3 inches.

 

[DCrake]

Twips are screen-independent units used to ensure that the placement and proportion of screen elements in your screen application are the same on all display systems. A twip is a unit of screen measurement equal to 1/20 of a printer's point. The conversion between twips and inches/centimeters/millimeters is as follows:
There are approximately 1440 twips to a inch (the length of a screen item measuring one inch when printed).

As there are 2.54 centimeters to 1 inch, then there are approximately 567 twips to a centimeter (the length of a screen item measuring one centimeter when printed).

Or in millimeters, as there are 25.4 millimeters to 1 inch, therefore there are approximately 56.7 twips to a millimeter (the length of a screen item measuring one millimeter when printed).

Note: Twips are sometimes confused with pixels, which is short for 'picture element'. A pixel is a dot that represents the smallest graphical unit of measurement on a screen. A pixel is screen-dependent; that is, the dimensions of screen elements vary with the display system and resolution.

 

[NewShoes]

Thanks to the both of you. This is exactly what I needed
-NS

 

[Galaxiom]

There are approximately 1440 twips to a inch (the length of a screen item measuring one inch when printed).

Precisely 1440 actually. A Twip (TWentieth of an Imperial Point) is a 1/20 of a Point (1/72 of an inch).

Access stores integer twips and for display of metric units converts using exactly 567 twips per centimetre. Unfortunately being a prime number, this is part of the reason Access does not display centimetre units very elegantly.

The other problem is at 0.00176 cm the twip is nearly twice the displayed centimetre precision. Why they bother displaying a resolution of 10 micrometers is a mystery to me.