A
Andy Banfield via AccessMonster.com
I am trying to write to a Memo field from a Form - the entries are
typically more than 255 chars. Using an Insert Into statement, the entry is
written to the table, but truncates at 255 chars.
If I replicate the query in the QBE SQL window, it does the same. Also, if
I run the sql as a simpe select statement, it also truncates.If I paste the
entry directly into the table, the full entry is accepted, so I know it's
not likely to be a problem with any restrictions on the table. It seems as
if the query is taking the field as a Text type, not a memo.
Any help is really appreciated!!!
typically more than 255 chars. Using an Insert Into statement, the entry is
written to the table, but truncates at 255 chars.
If I replicate the query in the QBE SQL window, it does the same. Also, if
I run the sql as a simpe select statement, it also truncates.If I paste the
entry directly into the table, the full entry is accepted, so I know it's
not likely to be a problem with any restrictions on the table. It seems as
if the query is taking the field as a Text type, not a memo.
Any help is really appreciated!!!