Option Group Txt rather than Number displayed in list box

[d9pierce1]

Hi all,
I did a mock up small db for this but I cant seam to figure out how to show the option group captions in my list box instead of the numbers?

1 = State
2 = City
3 = County

Dave


ListBox Sample.zip

[ranman256]

Set the list property,
Columnwidths: 0:2
columns=2

[d9pierce1]

Sorry, that wont do it, not the problem but thanks

[CJ_London]

option groups only store the number so you will need a function to display a name - something like

choose(license,"State","City","County")

[davegri]

ListBoxSample-davegri-v01.zip

Have a look at this.

[d9pierce1]

Hi Davegri,
That is just great! You are so good at this. Thank you so much and have a great night!
Dave

[davegri]

Happy to help - and thanks for the star click.