Hello Mark,
Don't know about this copy to clip board, this is how I would do it:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim tmp As Sting
Set db=Currentdb
Set rs=db.OpenRecordset("SELECT fldMemo FROM tblMyTable WHERE
fldID=1")
tmp=rs("fldMemo")
Open "C:\MyPath\MyFile.txt" For Output As #1
Print #1, tmp
Close #1
rs.Close
Set rs=Nothing
Set db=Nothing
After that you should have a textfile in the path and name you enter
(make sure it does not exist or it WILL overwrite) that you can open
with NotePad.
Hope I got all the code right, it's off the top of my head.
Watch out for the word wrap.
Regards
Robin.
--- In [email protected], "Mark Hallgath" <[EMAIL PROTECTED]>
wrote:
>
> 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
> <brett.collings012@> 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/
