Long strings get truncated in Access

From: jalil.feghhi@xxxxxxxxx
Date: Thu, 17 Jul 2008 17:28:41 -0700 (PDT)

I have an access database that has a field (type memo) that keeps very
long strings. When the value of this field is very long, my Visual
Basic 6.0 code does not return the whole value and truncates it. I
just read it using standard code like this:

storeId = rstMsg!storeId

where is defined as: Dim stMsg As ADOdb.Recordset

Everything works fine if storeid is not very big.

Does anybody know why this happens?

Thanks,

-Jalil

.

Follow-Ups:
- Re: Long strings get truncated in Access
  - From: Allen Browne
- Re: Long strings get truncated in Access
  - From: Tom van Stiphout

Prev by Date: Re: slightly O.T. - can A97 ensure HP 4200 printer is printing my reports in 1200 DPI?
Next by Date: #Name? error in Access 2003
Previous by thread: Expend by typing in a combobox
Next by thread: Re: Long strings get truncated in Access
Index(es):
- Date
- Thread

Relevant Pages

Truncation Issue w/ Strings
... I have an access database that has a field (type memo) that keeps very ... long strings. ... just read it using standard code like this: ... Everything works fine if storeid is not very big. ...
(microsoft.public.vb.general.discussion)
Re: Truncation Issue w/ Strings
... long strings. ... Everything works fine if storeid is not very big. ... You might want to look into the GetChunk() method of the Field object. ...
(microsoft.public.vb.general.discussion)
Re: Long strings get truncated in Access
... Check out the GetChunk method. ... Microsoft Access MVP ... long strings. ... Everything works fine if storeid is not very big. ...
(comp.databases.ms-access)