Setting Top Properties in VBA 3

[monika102001]

how can I change top property for text or label in VBA;depends on criteria
I tried:
If text1.Value > 0 Then
Text2.Top = 0.7396
Else
Text2.Top = 1.3958
End IF

It does not work!
Can anybody help me what I'm doing wrong!!!

 

[PHV]

The Top property is an Integer (no fractional part), it's a number of twips.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[boch]

So if yyou just modify your code to multiply the inches by 1440, you'll have your code working.

For Example: Text2.Top = 0.7396*1440

You may also need to refresh the screen.

 

[JerryKlmns]

monika102001

combining PHV's enlightful statement and boch's example you should use:

Text2.Top = Int(0.7396*1440)

for moving the control in inches expressed in twips ...

 

[monika102001]

Thank you very much!!!!It's working!!!!!You guys are great!!