Text Box dimensions VB6 numeric vs Acess 2003 inches

B

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

Stuart McCall

Bill said:
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.
Click to expand...

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
 
Top