Re: Truncation Issue w/ Strings

<jalil.feghhi@xxxxxxxxx> wrote in message
news:c5c2b21f-ec48-415d-b096-484b76ca54be@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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?

You might want to look into the GetChunk() method of the Field object.


.

Relevant Pages

  • 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: 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)
  • 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)