very strange!!!

[tppradeep18]

I have a table in SQL 7.0 which has a field called body of the type varchar and length 8000. I have stored some datain n body feild which is 1000 in length. When I retrieve the data in Visual Basic and display the data I get only first 255 chracters. Can somebody explain why this is happening.

[VBonliner]

Does your table has 8000 records or does your field
has a max of 8000 characters?

What I know is that in Access, the max number of
characters allowed in a field is 255 characters.

A text field can only contain 255 characters, but a memo field (=big textfield) can contain up to Max. 65.535 chars.

If the memofield is manipulated by objects for data-access (DAO) and only text & numbers are stored (no binary data) the field-length is only constrained by the size of the database.