Long strings get truncated in Access

[jalil.feghhi]

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

[Tom van Stiphout]

On Thu, 17 Jul 2008 17:28:41 -0700 (PDT), ja**********@gmail.com
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

[Allen Browne]

Access (JET) truncates the memo field if your query processes the data in
that field: aggregating, de-duplicating, formatting, and so on.

Details in:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja**********@gmail.comwrote in message
news:2b**********************************@z66g2000 hsc.googlegroups.com...

>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