Dropdown List

[Chris]

I want to add a 'Please Select.....' with a blank value to a dropdown. And
then remove it once a selection is made. What is the best way to do this.

 

[Guest]

Chris,
You can use the Items.InsertAt and .RemoveAt methods of the control.
Peter

 

[Jeff Dillon]

If you don't want to remove it, you can just add it to your original SQL

Select 'Please Select', 0
UNION ALL
Select fields from table