memo field to string variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Souris - 31 Jan 2008 17:38 GMT

I manipulate memo field which stoores text only in my VBA code to assign a
string variable in VBA application.

The string only keep part of the string.

What is the maximum characters memo fields information may assign to a
strign variable?

If the text from memo field is too long.
Any work around?

Your information is great appreciated,

Reply to this Message

Marshall Barton - 31 Jan 2008 19:23 GMT

>I manipulate memo field which stoores text only in my VBA code to assign a
>string variable in VBA application.
[quoted text clipped - 5 lines]
>
>If the text from memo field is too long.

A memo field and a string variable can hold more text than
you can read in a day. A text box can only hold 64K
characters.

How many characters are you getting and how many do you
expect to get?

If you are using a query to retrieve the memo field, check
if the query is or is not getting the entire memo field.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Linq Adams - 31 Jan 2008 22:51 GMT

Also important, I think, is exactly what you are planning on doing with this
string variable?

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message