Text Box In ASP Page Truncates Field Value When Writing Rst

Alex writes "Windows Server 2003 Enterprise Version - SQL server 2000
SQL Enterprise Mgr Version 8.0

I am currently developing a backend SQL db for an ASP website. I am only learning, so quite new to it all & would appreciate some help with the following;

I currently have a form that updates a recordset in my SQL db. This is working fine, except for the fact that when the form loads and the db tries to write the field value into my text box, e.g. Address: 20 Harbour Drive, the field value is truncated at the space and it writes the address as 20 in the text box.

When I view the detail page, no problems, the recordset was updated, but when I go back to the update page, the record values are truncated again as though the ASP page thinks the space is some kind of delimiter?

The size property of my textbox element is the same as the varchar datatype size in the SQL table.

Can anyone help?

Thanks in advance, this is driving me nuts.
Alex"