On a report, when I access the value for a control property, such as . . .

Me.StepStartLine.Top

I get an integer value, which I assume is pixels.

Is pixel the unit of measurement given for a control property? If so, how
can I convert it to inches?

My goal is to draw a line from a specific control to the end of the section
(which resizes depending on the data.) I'm trying to determine the Y value
to start the line. Here's my code . . .

Dim VerticalStart As Single

Me.ScaleMode = 5 ' Set Scale to Inches
Me.DrawWidth = 25

VerticalStart = *Value I Need*

Me.Line (8, VerticalStart)-(8, 22), vbBlack
Me.Line (0, VerticalStart)-(0, 22), vbBlack

Any suggestions are welcome.

It is not pixels, it is twips. there are 1440 twips to an inch.

But I can never remember how to convert miles per hour to furlongs per
fortnight

"Developer of the Caribbean" wrote:

> On a report, when I access the value for a control property, such as . . .
>
> Me.StepStartLine.Top
>
> I get an integer value, which I assume is pixels.
>
> Is pixel the unit of measurement given for a control property? If so, how
> can I convert it to inches?
>
> My goal is to draw a line from a specific control to the end of the section
> (which resizes depending on the data.) I'm trying to determine the Y value
> to start the line. Here's my code . . .
>
> Dim VerticalStart As Single
>
> Me.ScaleMode = 5 ' Set Scale to Inches
> Me.DrawWidth = 25
>
> VerticalStart = *Value I Need*
>
> Me.Line (8, VerticalStart)-(8, 22), vbBlack
> Me.Line (0, VerticalStart)-(0, 22), vbBlack
>
> Any suggestions are welcome.

Klatuu,

Works perfectly. Thanks much!

Robert

"Klatuu" wrote:

> It is not pixels, it is twips. there are 1440 twips to an inch.
>
> But I can never remember how to convert miles per hour to furlongs per
> fortnight
>
> "Developer of the Caribbean" wrote:
>
> > On a report, when I access the value for a control property, such as . . .
> >
> > Me.StepStartLine.Top
> >
> > I get an integer value, which I assume is pixels.
> >
> > Is pixel the unit of measurement given for a control property? If so, how
> > can I convert it to inches?
> >
> > My goal is to draw a line from a specific control to the end of the section
> > (which resizes depending on the data.) I'm trying to determine the Y value
> > to start the line. Here's my code . . .
> >
> > Dim VerticalStart As Single
> >
> > Me.ScaleMode = 5 ' Set Scale to Inches
> > Me.DrawWidth = 25
> >
> > VerticalStart = *Value I Need*
> >
> > Me.Line (8, VerticalStart)-(8, 22), vbBlack
> > Me.Line (0, VerticalStart)-(0, 22), vbBlack
> >
> > Any suggestions are welcome.