[AccessD] Row Limitations for ListBoxes

John W. Colby jwcolby at colbyconsulting.com
Fri Dec 10 06:25:32 CST 2004


The limit in this case will be the 2000 byte length limit of the rowsource
property.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Thompson
Sent: Friday, December 10, 2004 1:13 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Row Limitations for ListBoxes



What is the row limitation for a multi-select list box if the row source is

a) a query
b) a string of values separate by ";"
c) a list fill using the call back function (which I assume has no
limitation)

I need to build a sql string that inserts records via a connection execute
for all records selected.

Thanks for any help,

Bill Thompson

-- 
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