Unbound list box (Access 97) - too many characters

I am trying to add items from an array to an Access 97 list box. The code works fine when adding a few items, but now I've reached a limit of the list box. I get this error: "You can enter up to either 255 or 2,048 characters for this property...". I have 8000+ characters I need to add to a list-box type control. Are there any similar controls that I can use in place of the list box? Any other suggestions?


Forms.Item("PacketSelectForm").lstPackets.RowSourceType = "Value List"
Forms.Item("PacketSelectForm").lstPackets.RowSource = MakeString(LocalArray())


tia,

flynn

I am trying to add items from an array to an Access 97 list box. The code works fine when adding a few items, but now I've reached a limit of the list box. I get this error: "You can enter up to either 255 or 2,048 characters for this property...". I have 8000+ characters I need to add to a list-box type control. Are there any similar controls that I can use in place of the list box? Any other suggestions?


Forms.Item("PacketSelectForm").lstPackets.RowSourceType = "Value List"
Forms.Item("PacketSelectForm").lstPackets.RowSource = MakeString(LocalArray())


tia,

flynn
I usually have my listboxes create themselves from a table or a query.
(use a query if you want to eliminate possible duplicates from the table.)
I am sorry I do not have the gift of programing that many folks have here, so the old method of using the wizard will be required.
Try making a table using the items you wish to have show up on your list box, then use the wizard to make your listbox. From there you can have your list box made from the table. You should not run into the limits that way. In the properties box of the listbox, you can indicate if you wish the selection be made only from the list. I hope this helps.
Tom