memo field to string variable

[Souris]

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,

 

[Marshall Barton]

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.

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.

 

[Linq Adams via AccessMonster.com]

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

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com