[AccessD] determine count of records displayed in continuous form

This will give you the number of rows that *can * be displayed at the current form size:

rows = int((Me.InsideHeight - Me.FormFooter.Height - Me.FormHeader.Height) / 
Detail.Height)

To work out how many are actually visible gets a lot more difficult. 
You will have to take into account the situations:

where recordcount is < rows ( visible is always "recordcount" ) or  

where the user has jumped to the last (or new) record and then started scrolling through 
records  (visible is somewhere between "one" and "rows") - this one is far from trivial.

If you work out a way to do the second one, please post it :-)

-- 
Stuart


 

On 20 Aug 2009 at 12:51, jwcolby wrote:

> Is there a way to determine the count of records displayed in a continuous form.  By this I mean the 
> number of records actually showing, not the count in the recordset behind the form.
> 
> I don't believe I have ever seen a way to do this but I thought I'd ask.
> 
> -- 
> John W. Colby
> www.ColbyConsulting.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com