I have a form with a drop down box for a field. Its called "client". That Drop down box is automatically populated from a data base. It all works fine except for when I have a client name that has a space in it. For some reason when I submit the form, everything in that field from the space on, gets dropped. So when the data is posted to the next page, I'm left with only half of the client name.<BR><BR><BR>This is the statement I use to populate the drop down box....<BR><BR>SQLPopulateBox = "SELECT ClientName FROM tblClient ORDER BY ClientName" <BR><BR><BR>And this is the loop that actually builds the drop down box....<BR><BR>set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en SQLPopulateBox,objConn<BR>%><BR><SELECT name="Client"> <BR> <option value="None">Select a Client<BR><%<BR>Do while not objRS.EOF<BR>Response.Write "<option value=" & objRS("ClientName") & ">" & objRS("ClientName")<BR>objRS.MoveNext <BR>Loop <BR><BR>objRS.Close <BR>set objRS = nothing<BR> <BR>objConn.Close <BR>set objConn = nothing <BR>%><BR></SELECT></td></tr><BR><BR>Can anyone give me a clue as to what is wrong. I'm working with SQLServer if that helps at all.