using code builder to set height of a line

[ariel81]

hi,

i have drawn a "line1" in a report "height" is 3.75". i use the code builder to change the height of line1 using the statement

line1.height = 2

however instead of shortening line1 to 2", the line disappears during run-time. how to change the line1 height using code builder? thank you.

 

[spasticus]

vba works with pixels (i think - maybe twimp depending on the setting on the form properties) . anyway, the height of line is either being set to 2px or 2 twimp. im not sure if you can make it use cm or inches but try changing the height to 200 and see if you can see the line.

*i realise i sound stupid - that'll be because i am. i haven't changed sizes of stuff in vba before. so i could be wrong

 

[ariel81]

thanks......

 

[boblarson]

*i realise i sound stupid - that'll be because i am. i haven't changed sizes of stuff in vba before. so i could be wrong

No, you are actually correct. You use pixels for most sizes like width and height. Now, for a line, the Width determines length and the Height is the up/down length. If the Width is greater than 1 then the combination of withd and height determines the angle of the line. And, the BorderWidth will determine the thickness of the line.