insert memo type data into a table

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.
 
T

Tony Tillyer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Setting column width in a table with a macro is not working 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Black Lines appearing over table borders 0
Problem with printing a word document containing a table 0
Creating a Search using a combo box and then creating a report. 4
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How to make the shading look uniform around a double spaced line in MS Word? 0

Top