full listbox

[mcnewsxp]

my users have discovered a limitation to the listbox control. i believe the
listbox can only store around 33000 characters when using a value list as
the rowsource. if i use a query i can get everything they want in there,
but i can't add a selected item to an adjacent listbox and remove the item
from the orinal listbox.

how do i solve this problem?

tia,
mcnewsxp

 

[John W. Vinson]

my users have discovered a limitation to the listbox control. i believe the
listbox can only store around 33000 characters when using a value list as
the rowsource. if i use a query i can get everything they want in there,
but i can't add a selected item to an adjacent listbox and remove the item
from the orinal listbox.

how do i solve this problem?

Use a table to store the data, and include a field which indicates which
listbox each record should be displayed in. Base the two listboxes on Queries
selecting the appropriate subset of the records; requery each combo in
whatever event triggers the move.