how to get more than 512 characters in a memo type field from a fo

[Guest]

I can put the text in this field directly in the table. But... when I try
to fill the field via a form I get only the first 512 charachter followed by
some unreadable charachters. What is the problem here? Mayby I have to
specify something in the update macro?

 

[John Vinson]

On Sun, 23 Jan 2005 07:39:06 -0800, frank tries access <frank tries

I can put the text in this field directly in the table. But... when I try
to fill the field via a form I get only the first 512 charachter followed by
some unreadable charachters. What is the problem here? Mayby I have to
specify something in the update macro?

You may be specifying too *much*.

A Memo field will be truncated to 255 characters (I have NO idea why
you're getting 512 - UNICODE perhaps!?) if you specify any Format
property on the table field or on the form textbox, or if you are
sorting by the field. (UNION queries and Unique Values queries and
Totals queries also truncate, but they're not updateable anyhow so
that's not the issue).


John W. Vinson[MVP]