I have a table in Microsoft Access whereby the field, 'msgbody', is of data
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?