How to insert data more than 255 into memo field?

How to insert data more than 255 into memo field?

Post by QmVybmFyZC » Wed, 18 Jan 2006 13:03:02


I have a table in Microsoft Access whereby the field, 'msgbody', is of data
type 'Memo'.

I have the following query with the name 'inboxIns':
PARAMETERS vnSeqNum Long, vsMsgType Text ( 1 ), vsMsgBody Text ( 1024 );
INSERT INTO inbox ( seqNum, msgType, msgBody )
VALUES (vnSeqNum, vsMsgType, vsMsgBody);

When I execute this query, the prompt for 'msgBody' will only accept up to
255 chatacters, but I want to insert data which is more than 255. How do I go
about doing so?
 
 
 

How to insert data more than 255 into memo field?

Post by Marshall B » Wed, 18 Jan 2006 13:48:51


The Input box that is used to enter paramerter prompt values
only accepts 255 characters.

Use VBA to assign the parameter values.

Or, better, create a bound form to enter the records.

--
Marsh
MVP [MS Access]