Null Values in a list box

[webstaff]

Hi Guys,

List Box question, using DW MX on winXP

To populate the list and values are no problem,

Say the list hold a list of titles to pick from

Doctor value= Dr.
Minister Value = Rev.
No Title value =
Etc
Etc

But I want the initial value of the list to be blank and hold a null value, so that the user filling in the form does not need to touch the list box if the record has no title.

In my list box values if i put say "No Title" as the initial selected choice with a value of "Null" - nothing entered in the value, It saves the text "No Title" to the database!!
If No Title is selected I want nothing to be entered,

Can anyone suggest how to get a null value into my list box values so that nothing gets saved to my database.

Thanks again
C

 

[ChrisHirst]

... value ="" selected="selected">No Title

The value should be in quotes

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
Nightclub counting systems

So long, and thanks for all the fish.

 

[webstaff]

Thank you, I dont know why i never thought to try that.
Regards as ever
C