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