22
I have a combo box that I add items too when the form is activated. I am using a range where clause to get records from a table that I use to populate the items. In Sql Server running the same conditions I get twice as many items than what is actually loaded into the combo box. Is there some limit that is casing this behavior?
Hi Erick
The limit for a list field is 32768 items.
Make sure that you clear the field before using a loop to add items.
If you want to remove the selection without removing the added items, set it to 0, or string = "" for combobox. don't use the clear command as that will remove the items.
Sounds like you fixed It with your by number issue.
Always make sure that ranges and get/change table commands are all operating on the same index and that the indexed range is set using the key fields for that index.
Also see my articles below for info on using ranges.
https://winthropdc.wordpress.com/2018/02/21/dexterity-future-proof-range-setting/
https://winthropdc.wordpress.com/2018/02/26/dexterity-well-behaved-ranges/
Regards
David
Ok I think I figured it out. Not the behavior I'd expect for this, but my 'get first table' command was missing the trailing 'by number 2'. I thought without it records would still be retrieved but somewhat randomly, not that half the records would appear and the other half would not show at all.
Adding that fixed it so that all the items were loaded into the combo box like I had wanted.
Thanks for your input Suresh, though it wasn't the answer it did refocus me to look in a different way.
Hi Suresh,
Thank you for your reply. That was my initial thought of what might be limiting it. Didn't really think so but behavior seemed odd. I made the maximum number larger to see if it changed anything, but as you point out the number of items just shows what is visible in the drop down with a scroll bar to see the rest. Some more info: The total number I expect to see there is 164 items only about 80 are added. Also the list is a list of names sorted alphabetically , yet nothing from A - M is displayed, Just N- Z. There is no condition limiting the items to be N - Z. When I run the exact conditions in a query in Sql Server I get all the values.
Hi Erick,
Did you try this >> (From Dexterity Help file)
Drop-down lists and combo boxes:
Use the VisibleItems property to specify the maximum number of items that will be displayed by a drop-down list or combo box in the dropped state. If the drop-down list or combo box has more items to display than can fit in the list, a scroll bar is drawn automatically.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
