[AccessD] Has anyone ever sen a listbox not display all rows?

David McAfee davidmcafee at gmail.com
Wed Jul 29 19:49:27 CDT 2009


I have a listbox on a tab control on a form in an ADP. A2003.

A user called to tell me that a certain transaction wasn't showing up in the
machine history tab.

When I attempted to see why that one transaction was falling out in the
stored procedure, I noticed it was in the result set.

I look at the rowsource for the list box, which is correct:

EXEC stpGetMachHist 17631

17631 is a numeric ID.

The listbox only displays five rows:
07/28/2009        Sold under transaction # OI/009049/09
06/26/2009        Credited under transaction # CRI/000654/09
11/27/2008        Warranty Expired
07/07/2008        Stock Transfer to 21000 under Tran# STK/000352/08
04/08/2008        Transferred to (21010) MOC Colorado under Tran#
OI/004770/08

If I copy and paste "EXEC stpGetMachHist 17631" from the list box controls
property into SQL Server Management Studio and hit F5 (Execute)
I get:

07/28/2009        Sold under transaction # OI/009049/09
06/26/2009        Credited under transaction # CRI/000654/09
11/27/2008        Warranty Expired
07/07/2008        Stock Transfer to 21000 under Tran# STK/000352/08
04/08/2008        Transferred to (21010) MOC Colorado under Tran#
OI/004770/08
12/11/2007        Credited under transaction # CRI/001445/07
11/28/2007        Transferred to (21010) MOC Colorado under Tran#
OI/016776/07
11/28/2007        Warranty begins
07/12/2007        Machine Released from WO# EQP00H000263/07

Column count is correctly set to 3 (I deleted the names of the personal from
this email)
It appears that the bottom (oldest) four transactions arent appering.

But get this! if I click in the list box the blank rows get selected as if
data is being diplayed!!!
If I then go to the immediate window and type this:
 ?forms!frmRentalMachines3!lstMachHist.column(2)
Transferred to (21010) MOC Colorado under Tran# OI/016776/07

Any ideas???

David



More information about the AccessD mailing list