[AccessD] determine count of records displayed in continuous form

Dan Waters dwaters at usinternet.com
Thu Aug 20 13:39:41 CDT 2009


If the form doesn't change height dynamically, then how about:

Const Max
Max = {Actual Max Number Of Rows}

Set rst = me.recordsetclone
rst.movelast
If me.recordsetclone.recordcount >= Max then
	DisplayedRowCount = Max
Else
	DisplayedRowCount = me.recordsetclone.recordcount
End if

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, August 20, 2009 11:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] determine count of records displayed in continuous form

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





More information about the AccessD mailing list