List box issue in Access 97

  • Thread starter Thread starter Thakur8385
  • Start date Start date
T

Thakur8385

You would be aware the List.additem is not available in MS Access 97.
Could you please suggest alternative way to add items to a list box runtime.
 
If the RowSourceType is Table/query, see:
http://allenbrowne.com/ser-27.html

If it's a Value List, you can append the new value to the RowSource, e.g. if
it currently contain:
1;2;3
you could add 4 like this:
With Me.Combo1
.RowSource = .RowSource & ";4"
End With
 
Just be aware that Access 97 had a much lower limit on the length of string
that could be used for the RowSource property than in subsequent versions,
so there's a limit as to how many items you can add.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating a list box in Access 97 4
list box 4
List Box in Access 97 2
Mousehook DLL issue 5
Two multi-select list boxes 3
list box remove item 1
control list 4
List Boxes - Access 2003 0

Back
Top