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/
