How to insert data more than 255 into memo field?

[Bernard Lim]

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?

 

[Marshall Barton]

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?

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.