Adding blank to databound combobox

[Dawn Nedohin-Macek]

I have a combo box which is databound to a SQL database. The database table does not include a "null" or "blank" entry. I would like the user to be able to select a blank to clear the current data which is set.

Currently, if there is no data and the user does not change the combo box, it works fine, however if they change the selection in the combobox, the blank disappears.

I tried changing the SelectedItem property to -1 and to Nothing, but it still shows the first item in the list.

Thanks

[mike]

set the data source query for your combobox to include a union clause with a null or blank value.

eg.
my combobox datasource
SELECT Data FROM Table
UNION ALL
(SELECT '')
ORDER BY 1;

this should put the blank option as the first entry in the combobox list.

hope this helps

> I have a combo box which is databound to a SQL database. The database table does not include a "null" or "blank" entry. I would like the user to be able to select a blank to clear the current data which is set.
>
> Currently, if there is no data and the user does not change the combo box, it works fine, however if they change the selection in the combobox, the blank disappears.
>
> I tried changing the SelectedItem property to -1 and to Nothing, but it still shows the first item in the list.
>
> Thanks
>