I am having trouble filling data into my form so that I can update table 

data.  I have no problem with Access Text Fields, but can't seem to be 

able to retrieve Memo, Numeric, and Date fields.  Also is there an easy 

way to retrieve data into a form with a Select Option.



Also is there a way to display numbers with commas when listing numbers on 

a page.



Any information you can give me would be helpful to me.  I want to thank 

those in advance those who will respond to my question, and also thank 

once again those who have helped me with past questions.



Thank You.



Here is my code I am trying to work with:



<%  Set Connect = Server.CreateObject("ADODB.Connection")

    Connect.Open "ProjectInfo"

    Set objRS = Server.CreateObject("ADODB.Recordset")

    

objRS.Open "Proj_Info",Connect,adOpenDynamic,adLockOptimistic,adCmdTable

  

    strRecord = Trim(Request("Item"))

    strCriteria = "ProjectNbr LIKE '" & strRecord & "*'" 

    objRS.Filter = strCriteria

%>



Please fill in all of these fields below.

When you are finished, click the Submit Record button.<p>





<form method="post" action="ProjUpdated.asp" name="ProjEdit" >

<table>

<tr><td>Project Number:</td>

<td><input size="50" name="ProjNbr" value="<%=objRS("ProjectNbr")%

>"></td></tr>



<TR><td valign=top>Project Name:</td>

<td><input size=50 name="ProjectName" value="<%=objRS("ProjectName")%

>"></td></TR>



'This is my Access MEMO field

<TR><td valign=top>Description:</td>

<td><TEXTAREA cols=50 name="Description" value="<%=objRS("Description")%>" 

rows=6></TEXTAREA></td></TR>



'This is my select/option form field

<tr><td>Water System:</td>

<td> <select name="WaterSystem" size="1">

  <option selected value="Lihue">Lihue-Hanamaulu</option>

  <option value="Kapaa">Wailua-Kapaa</option>

  <option value="Koloa">Koloa-Poipu</option>

  <option value="Waimea">Waimea-Kekaha</option>

  <option value="Haena">Haena-Wainiha</option>

</select></td></tr>



<tr><td>Location:</td>

<td><input size="10" name="Location" value="<%=objRS("Location")%

>"></td></tr>



<tr><td>Project Type:</td>

<td><input size="15" name="Proj_Type" value="<%=objRS("ProjType")%

>"></td></tr>



<tr><td>Project Manager:</td>

<td><input size="50" name="Proj_Mgr" value="<%=objRS("ProjMgr")%

>"></td></tr>



'This is my Access Numeric field

<tr><td>Percent Complete:</td>

<td><input size="3" name="Pct_Complete" value="<%=objRS("PctComplete")%

>"></td></tr>



<tr><td>Estimated Cost:</td>

<td><input size="50" name="Est_Cost" value="<%=objRS("EstCost")%

>"></td></tr>



<tr><td><input type="submit" name="pagesub" value="Submit 

Record"></td></tr>

</table>

</form>