Brett, I agree with your assessment. I normally do not store more than 40 characters in a field. But, I have recently taken a job at a company that references US government files. They use MS-Access to streamline their report breakouts. The Memo field in question is populated with govnmt legal jargin that I am not allowed to manipulate, other than to publish it in spreadsheet.
I performed a search of previous messages in this group and was not able to locate previous postings regarding this issue. I will modify my search criteria and try again. Thanks, Mark --- In [email protected], Brett Collings <[EMAIL PROTECTED]> wrote: > > Mark, sorry I don't have the answer but one of the others does, I just > can't remember who. You'll hear from them shortly for sure. This > question comes up here at least every 10 days, I just haven't taken > notice except to know it's something to stay away from. > > Basically a database is not the ideal place for large globs of > memo-field type information - especially if they're larger than 255! > > Brett > > > > Mark Hallgath wrote: > > > I have an MS-Access which has a field datatype set to Memo. A datatype > > of Memo is supposed to hold up to 65,535 characters. > > > > While I am able to insert and view more than 255 characters into this > > field, I am only able to copy/paste a max of 255 characters from this > > field into Notepad and/or MS-Excel. > > > > I have also queried from MS-Excel against the MS-Access database but > > got the same results (max 255 characters). > > > > Can anyone advise me how I can copy the total number of characters from > > an MS-Access table (Memo) field into Notepad or MS-Excel? > > > > Any assistance is much appreciated! > > > > Thanks, > > > > Mark > > > > > > > -- > Brett Collings > Strengthening Families Administrator > D2D 46422 > DDI (04) 916 3422 > > > ------------------------------- > This email message and any attachment(s) is intended only for the > person(s) or entity(entities) to whom it is addressed. The > information it contains may be classified as IN CONFIDENCE and may be > legally privileged. If you are not the intended recipient any use, > disclosure or copying of the message or attachment(s) is strictly > prohibited. If you have received this message in error please > notify us immediately and destroy it and any attachment(s). > Thank you. The Ministry of Social Development accepts no > responsibility for changes made to this message or to any > attachment(s) after transmission from the Ministry. > ------------------------------- > > > > [Non-text portions of this message have been removed] > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
