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