list box size restraints

[dogdays]

Win 7 32 bit pro, Access 2003
I have a list box with 404 rows, total size of the value list I am using for the rowsource is 42,059 characters. I get Error 2176, The setting for this property is too long. What are the maximum for the number of rows and length of the value list used to populate the list box?
Google tells me max rows is about 65K, no mention of value list size.

tia Jack

 

[dogdays]

Bob:

The list box contains enough data about each row in tblAcquisitions for the user to be able to select a desired row for editing or deleting. I have no problem dynamically generating the SQL. The idea of using a subform seems to have merit. I could display the same amount of data about each row as I do in the listbox and when the user clicks on any row then display the form to edit the row.
There is too much data in each row to present it to the user on a single line.

Jack

 

[Norie]

Jack

You should definitely look at subforms, and more generally forms.

Perhaps even a continuous form which could in a way take the place of the listbox.

With a continuous form you could display all the records with enough information for the user to select the one of interest.

They could also use the built-in sort and filter functionality of Access.

Once they've identified the record they want they a button could be pressed to open a form with the full record.

You might need a little code for that part but not for the rest.

 

[dogdays]

Norie:

Sounds like a plan, thank you.

Jack