Total detail section height

  • Thread starter Thread starter Ilya Margolin
  • Start date Start date
I

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
 
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.
 
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

Wayne Morgan said:
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


Ilya Margolin said:
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
Click to expand...
Click to expand...
 
Back
Top