What are the field position values in VBA?

K

Keith

I want to move fielde about on a form depending on what button I press. I
thought I had it all worked out but it seams that the Left field on the
property sheet is in centimeters, but something else when I use VBA.

Does any body know what the conversion ratio is between the two values?

I tried adding cm to the end of my value in VBA but it didn't like it.
 
A

Al Camp

Keith,
I take it that you are not in the US.
Here the "properties" box for measurements accepts inches.
When referring to those values in VB, you would use "twips" @ 1400 to our inch... or to
your 100 centimeters... or 14 to 1 centimeter (if I figured correctly)
 
D

Douglas J Steele

When using the Properties box, Access uses whatever unit of measure has been
specified in Regional Settings (inches or cm.)

There are 567 twips to the centimeter.
 
A

Al Camp

Doh! Glad I put a caveat in there!
But... if 1cm = .393 inches then wouldn't 1400 * .393 = 550 Twips per centimeter
Just curious...
Al
 
K

Keith

Thanks for your help.

So can I take it then that there are 567 twips to a cm then, and old Bill
can't count properly? :)
 
Top