Could someone help me. THis is the code I am using to display a record from the database to a form

For some reason some of the fields in the record do not populate the text boxs and text areas.

Could it be the connections, the database setting? I am really baffled. When I open the database in Query analyzer all the data is there.

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=amigos.sql.93;UID=amigos;PWD=ZZZZZZ;DATABASE= ZZZZZZ"
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM tbl_Courses where CourseID = " & request.querystring("CourseID")
objRS.Open strSQL, objConn%>

<input type="text" name="Score" size="10" value="<%=objRS("Score")%>">

<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Any help would be greatly appreciated...

Here is a little note to myself which I had previously written about brackets. Don't know if this might apply to you as well somehow.

<<
Need to put brackets around and often the table name and a period before field names that contain odd characters such as spaces or have names that conflict with other things such as field names like Date, Password, Position, Quantity, or User.

Example:
MyTable.[Position]
>>

So you might try brackets around the field names.

It is better to use If statement when you retrieve data from record set

<% If Not RS.EOF Then %>
<input type="text" name="Score" size="10" value="<%=objRS("Score")%>">
<% End If %>