# valuelist only showing 100 items

**URL:** <https://forum.servoy.com/t/valuelist-only-showing-100-items/20940>\
**Category:** Questions\
**Created:** [January 21, 2023, 9:12pm UTC](https://forum.servoy.com/t/valuelist-only-showing-100-items/20940 "2023-01-21T21:12:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ManChicken](https://avatars.discourse-cdn.com/v4/letter/m/bbe5ce/32.png) [@ManChicken](https://forum.servoy.com/u/ManChicken)\
**Post date:** [January 21, 2023, 9:12pm UTC](https://forum.servoy.com/t/valuelist-only-showing-100-items/20940/1 "2023-01-21T21:12:52Z")

</div>

I have an old solution originally made under Servoy version… I actually can’t recall! Whatever was current circa ~2009 ![:D]( "Very Happy") – and it’s been upgraded through the years where I’m currently running on Servoy 7.4.

Anyway I have a form with a text field set to TYPE\_AHEAD and connected to a valuelist which uses a relationship to pull values from another table to show project names matching a client number. However the valuelist is only showing 100 entries, which 99% of the time is more than enough, but I do have one client with (currently) 106 projects. I can access them by typing in enough to cause the typeahead to filter out some entries, but it’d be nice if it could just show me everything.

Everything I can find in searching seems to say that the valuelist limit was increased to 500 eons ago (before I ever used Servoy) and I even tried bringing my solution into test Servoy 8 and 2022 installs to no avail… still 100 shown. I’ve looked at the query it’s sending to my MariaDB server and it does return all 106 rows.

I feel like I am either missing a property setting somewhere, or it’s just not been defined in the documentation (that I’ve found) that perhaps while a valuelist can return up to 500 items, the actual UI widget in the Smart Client won’t display more than 100 a time?

---

<div class="post-metadata">

**Author:** ![rafig](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/rafig/32/4463_2.png) [@rafig](https://forum.servoy.com/u/rafig)\
**Post date:** [January 23, 2023, 3:57pm UTC](https://forum.servoy.com/t/valuelist-only-showing-100-items/20940/2 "2023-01-23T15:57:58Z")

</div>

Easiest thing to do is to load up the value list manually, then it can have more than 100…  
see

```auto
application.setValueListItems

```

Hope that helps.