Line height in a sub report

M

Manuelauch

I have a vertival line that I want to make the same height as a text box via
VBA. I make the height of the line the same as the height of the text box,
but it does not work. A set public variables and I can see that the line H =
270 and the text box H = 300, but in the property box in design the height of
a control is set in inches. Any suggestion
 
T

Tom Wickerath

The heights you see in the public variables are in pixels. There are 1440
pixels per inch, so your line height is apparently 270/1440 = 0.1875 inch,
while the text box is 300/1440 = 0.2083 inch. Perhaps this KB article will be
helpful to you:

How to Create a Line That Can Shrink and Grow in a Report
http://support.microsoft.com/kb/197595


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
Lebans TextHeightWidth in sub-report 0
Place Text box at Mouse Pointer Position on a page 0
Access report - growing text box 2
Newbie: Formatting text in a report? 2
Adjusting height of text cells 3
Set a minimum row height a the same time with autofit row height 1
Height alignment in reports 0

Top