Re: Long strings get truncated in Access

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

Check out the GetChunk method.
-Tom.
Microsoft Access MVP

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
.

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)
  • Long strings get truncated in Access
    ... 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. ...
    (comp.databases.ms-access)
  • 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)
Loading