list box

F

Fipp

I have a list box that is based off a value list. I would like there to be an
option where none of the values are selected. Right now if you click on one
it is turned on and I have no way of changing it back to a null value.
 
F

fredg

I have a list box that is based off a value list. I would like there to be an
option where none of the values are selected. Right now if you click on one
it is turned on and I have no way of changing it back to a null value.
Click to expand...

If all you want to do is unselect a selected value, and afre willing
to double-click the control, code the list box double-click event to:

Me![ListBoxName] = Null

If you do wish to show a Null value, then set the Value List property
to:

"","ValueA","ValueB","ValueC", etc.
 
Top