Total detail section height

[Ilya Margolin]

Hi All,

I am trying to calculate total height of all detail sections by adding up
Me.Detail.Height to a counter in the Detail_Print event. In each occurrence
of the event the height is all the same 375 regardless of the actual height
of about 750 (measured with a ruler). The result I am getting about 2 time
smaller then it ought to be. Am I missing something?

Thanks,

Ilya

 

[Wayne Morgan]

Testing this, appears that the format and print routines don't always need
to run. To get around this, I placed a textbox in the detail section (hidden
if you prefer) and set its control source to

=[Detail].[Height]

I then set its running sum property to over all. The value of this textbox
in the last record is what you're after.

 

[Ilya Margolin]

Thanks for your reply, Wayne.

What I eventually did was totaling up the height of a text box which defines
the height of the section.

Ilya

Testing this, appears that the format and print routines don't always need
to run. To get around this, I placed a textbox in the detail section (hidden
if you prefer) and set its control source to

=[Detail].[Height]

I then set its running sum property to over all. The value of this textbox
in the last record is what you're after.

--
Wayne Morgan
Microsoft Access MVP

Hi All,

I am trying to calculate total height of all detail sections by adding up
Me.Detail.Height to a counter in the Detail_Print event. In each
occurrence
of the event the height is all the same 375 regardless of the actual
height
of about 750 (measured with a ruler). The result I am getting about 2 time
smaller then it ought to be. Am I missing something?

Thanks,

Ilya