How to insert data more than 255 into memo field?

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

Guest

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?
 
Bernard Lim said:
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?
Click to expand...


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