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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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]
 
Back
Top