Record height (1 Viewer)

[jca]

I have a sub-form open in continuous mode. So, I see a repetition of the form because there's more than one records active.

What I would like to know is the total height of the form. Not the height of the sub-form frame. Just the height of one record would also be ok since I will only have to multiply it by the recordcount.

Any idea on the subject would be welcome.

thanks,
JC

 

[ChrisO]

Try this it may be what you're after.

Me.FormHeader.Height + Me.FormFooter.Height + (Me.Detail.Height * Me.RecordsetClone.RecordCount)

It could lead to incorrect values depending on how many records you have. Maybe, maybe not.

Regards
Chris

 

[jca]

Thanks, I'll try it as soon as I can