Database Setting for text box and text area forms

I have a SQL Server database. The data from a table is populated in the table and can do a regular display query on a record without issue.

Problem is when I pull the data into a form the data doesn't show up in some form fields for editing.

I am building a backend for the manager to make updates and changes and this is vital. Does anyone know if it has something to do with a database setting or has had a similar issue in the past?

The reason I think its a database setting is becuase the same table converted into MS Access has no problem populating the text boxs and text areas.

Your help is much needed and appreciated.

Thanks.In case anyone is interested. You can solve this with a work around. Set a vaiable for the field item then use the response.write the variable to popluate the text box or text area.

database replication

Hi, newbie here.
I have an sql express database on my local machine (xp sp2) with many tables populated with plenty of data.
How can i duplicate/replicate this database?
Seems like it should be a straight forward thing, but i guess not.

Thanks!
-GarySQL Express can only subscribe to a replication, it can't publish I'm afraid.