Text Box dimensions VB6 numeric vs Acess 2003 inches

[Bill]

Hi Folks,

I find I need to create a routine that I had written in VB6 and create
it in Access 2003. I have a bunch of text boxes on the form.
VB6 has for example the property Left value 6720.
When I look at Access the values look like they're in inches.

Is there a formula to convert from like 6720 to inches?

I'm trying to get the forms to look very similar.

Thanks,

Bill
PS My actual email address is b i l l t e s t 0 0 2
and it's on hotmail.
I do this because I get enough spam as it is.

 

[Douglas J. Steele]

The dimensions are in twips. There are 1440 twips to the inch.

 

[Stuart McCall]

Hi Folks,

I find I need to create a routine that I had written in VB6 and create
it in Access 2003. I have a bunch of text boxes on the form.
VB6 has for example the property Left value 6720.
When I look at Access the values look like they're in inches.

Is there a formula to convert from like 6720 to inches?

I'm trying to get the forms to look very similar.

Thanks,

Bill
PS My actual email address is b i l l t e s t 0 0 2
and it's on hotmail.
I do this because I get enough spam as it is.

As Doug has mentioned, the values in VB are twips. VBA also uses twips, so
instead of looking at the form design property sheet, switch to VBA and use
the immediate window, like:

?Forms!MyFormName!MyControlName.Left

You can also set the properties from here:

Forms!MyFormName!MyControlName.Left = 6720