Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use firstsortedvalue function to highlight in QV default green the first displayed value in a list box.
Gerry.
Afaik the only way to highlight a value in a listbox is to select it.
I do not think,
If it were possible I would not do that as it would confuse the user
Maybe create a one-column straight table, and highlight it there. And, better to use a different color than the "selected green" to avoid confusion.
Like Michael suggested, that is the way you can fake a listbox using a straight table and still retain the functionality of a list box with the bonus of additional formatting that a straight table offers. i remember seeing examples here on community. you may want to search. i will post the link if i find it.
You could do something like this ... displaying a Text Box above the List Box in the default green color with the first value from the List Box displayed ...
In this case I used =MinString(Regions) - but that could just as well be =FirstSortedValue(....)