How to concatenate string to memo

[Oliver Kinne]

Thank you for your reply.

However, my problem is that GetChunk ALWAYS returns the FIRST(!) so many characters of the memo field.

For example:

memo field: This is a very long text field. There is heaps and heaps of text in here. Wow. Really big.
GetChunk(1,10) = "This is a "
GetChunk(10,10) = "This is a "
GetChunk(20,10) = "This is a "
...

I.e. GetChunk does NOT work in VB for Access. What am I doing wrong?


Hope this helps?
Oliver