I have used the x.dbMemoTextSize property with my Access databases that have a memo field in them before, here is my current predicament.

I am using MS SQL7.0 and I have a database that has a field that needs to be large like a memo field in Access. I am using a varchar field property with a length of 1000 characters currently and it works fine. The problem is that when a user goes into add a new record to my db, the field that is 1000 characters long, needs a memo field instead of a regular text box. Is there a way to associate SQL's varchar property with a memo field in ASPdb? Any help is greatly appreciated. Thanks!

Jeremy Kinser