If you have a field declared as a memo type, you can include it on a form and can have data entered in it as with any other field type; you cannot do a find or filter operation on any of the memo field's contents, but you can enter it. The main problem I have found with reports is that if it is in a table linked in with a query, it may get truncated, and I believe my solution there was to have the memo field in a subreport rather than in the main report.
Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of selva_be_1 Sent: Wednesday, July 27, 2005 11:22 AM To: [email protected] Subject: [AccessDevelopers] need help in memo Hai, I hope memo cannot be handled as strings(text). I want to get the long message in text box and store in the table in access database. This cannot be achived with text datatype, as it can hold only data upto 255 characters length. The only option is to go for memo. Can anyone help me to know how to store the message from text box to the field with memo datatype and also how to retrive memo data in report. Selva Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
