insert memo type data into a table

  • Thread starter Thread starter erdo
  • Start date Start date
E

erdo

I made a table with a Memo data type field. I can insert
text longer than 255 into the table manually (from table
datasheet view). But when I try with a insert query
(attached to Combo Box in a form) it does not work. Query
is as follows.

INSERT INTO Customer_tbl ( Description )
VALUES ([forms]![Customer_frm]![Description_cbx].Value);

When I write short text the query works properly but with
a longer text it does not.

any help would be appreciated, thanks.
 
Try looking at the settings for the Format of the Field in the Query, rather
than the settings for the same Field in the Table.

Frequently, you find that a Table Field type has been updated, but the Query
or Macro has not been updated to reflect the changes...

HTH

Tony Tillyer
Bugger All Qualifications
 
Back
Top