Unbound Text Box...Truncated value

[birgitd]

I have a SQL Server database/Access project configuration. I have a field in SQL Server set up as a varchar(2000) ... it's a comment field and people need to write a lot.

I have the user type their text into an unbound text box field on a form which I then use to build an insert query in a module (..comment = screen.activeform.txtcomment). The problem is that if the user types in more than about 50 characters, they get an error stating that the values will be truncated.

I can find no documentation about built-in constraints on unbound fields (or how to work around this problem).

Any ideas would be greatly appreciated.

Thanks!
Birgit

 

[rajeessh]

If you are storing the temproray data in local tables
and then saving in SQL Server
The Temp Table of MDB where you store or log the data before
saving to SQL Server will be of length 50
By default the Size of text type of fields is 50 and
max of 255
If you want to go more than that make the field as memo in
MDB

SQL Server can be varchar or nvarchar