Force The Value Of A List Box

[AndyShuter]

I wonder if there is any way in which I can force the value of a List Box by using an "On Click" event?

for example, I have a listbox which has 5 Values in

Accepted
Declined
Pending
Paid
All

What I would like to do is create an event that highlights the "All" value

Many Thanks, as ever

 

[ghudson]

Me.YourListBox.Value = "All"

 

[AndyShuter]

erm its not working, it is set to multi select by the way

 

[AndyShuter]

Got it working using the ListItem Property,

Only problem now is I need to set the Order of the listbox to show the value "ALL" in the first row, then sort the rest of the records by alphabetical order!!!

Any suggestions?

Regards

Andy

 

[Mile-O]

If these are the only five options you have - and probably ever will - then you could use a Value List and order it yourself.