textbox displays only 256 characters

  • Thread starter Thread starter rmanchu
  • Start date Start date
R

rmanchu

hi

using Access 2003

i've got text box that refuses to accept text > 256, it trucates and
displays the text that exceeded the limit

my form is powered by ADODB.Recordset retrieved from an SQL Server. i
know the field holds more than 256, actually > 700.

what's wrong?

thanx
riyaz
 
Is there anything in the Format property of the text box? If so, remove it.

Is there anything in the SQL statement that would cause Access to
de-duplicate the records, e.g. a DISTINCT predicate or a GROUP BY clause?
 
Allen said:
Is there anything in the Format property of the text box? If so, remove it.

Is there anything in the SQL statement that would cause Access to
de-duplicate the records, e.g. a DISTINCT predicate or a GROUP BY clause?
Click to expand...

no, nothing of the sort

http://groups.google.com/group/micr...+access+textbox+limit&rnum=2#019870e100778049

i came across this post; it says its a bug in Access 2002, i guess its
stil there in Access 2003????

before i try what's suggested there; ie changed VARCHAR(>255) to TEXT
on SQL server ...
any ideas?

thanx
riyaz
 
hi

am postiing back just to confirm that this problem seems to be, indeed,
a Access 2003 bug.

as per the link in my earlier post, changing VARCHAR(>255) to TEXT in
SQL Server does indeed work correctly. access refuses to send more than
256 chars to a varchar field!

this is a serious bug, since access is often used for frontends to
sqlserver!
especialy after being documented for access 2002.
:(

thanx
riyaz
 
Back
Top