List Box with blanks

[rido1421]

Hi There

I have a list boxes that im using in sort of a hierarchy structure

In the Parent list box I select Car

In the child list box the brands should appear , Toyota,Mazda Etc ,

My Problem is that there are a whole lot of Blanks in the child list box instead of putting the relevant fields at the top of the list box

you find them as you scroll down... I need the relevant available children brands to appear at the top... any Idea what I could of done wrong or can change in the list box?

Regards,

Ridhaa

[tresB · Accepted solution]

Sort tab, sort by expression(ascending), like:

=if(Len(Trim(ChildCarField))>0,ChildCarField)

Or , if you want spaces out of listbox, try the same expression in the general tab->field->expression (as if a calcuation dimension).

[rido1421]

Thank you works perfectly