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