full listbox

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

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
 
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?
Click to expand...

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.
 
Back
Top