I seem to remember that there was/is a limit of 4kb on the Choose command - could you be coming up against this?
If the width of your display is large then the number of rows available will decrease. ComboBox and ListBox controls don't seem to have any limits... Regards, Alastair. ----- Original Message ----- From: "Joel Solomon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, May 23, 2005 4:46 PM Subject: [RBG7-L] - Memory allocation > Good Morning, > > I would like to know if anyone has run into this problem. I get an error in > my form lookup that states that I do not have enough memory to allocate to > the lookup function. I have only 1,200 records and I am using a > multi-column lookup using 3 text columns. My computer has 512 MB of memory > and I am running Windows XP. When I change the mulit-column lookup to 2 > text columns, the error goes away. > > Short of increasing my memory, what else can I do? I find it quite strange > that 1,200 records would cause this kind of problem. > > Thanks > Joel Solomon > V.P. Finance > Barbizon International > [EMAIL PROTECTED] >
