What are the field position values in VBA?

[Guest]

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.

 

[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)

 

[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.

 

[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

 

[Douglas J Steele]

Good question. Must be another example of Microsoft redefining the world...
<g>

http://msdn.microsoft.com/library/en-us/off2000/html/defTwip.asp

 

[Guest]

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?