Two issues come to mind.  First, if the source of the memo field's data is
not your program, then you may cause the loss of RTF formatting.  Second,
the maximum capacity of the Textbox object is 32,768 -- a memo-type field in
Access can hold up to 64,000 characters.

Pete

-----Original Message-----
From: Talon Wolles [mailto:ta_iwo@y...]
Sent: Thursday, January 30, 2003 7:12 PM
To: professional vb
Subject: [pro_vb] RE: Accessing a memo field


Pete, can I use the ordinary text control  to archieve
same assuming I don't want to use the RTF component?

-Talon

--- "Peter N. Kipe" <pkipe@c...> wrote:
> Use a Rich Text Box (component:  Microsoft Rich
> Textbox Control).  To save
> text plus all text formatting, move object.TextRTF
> to the recordset field.
> If you just want text, say, to display in a MsgBox,
> use object.Text.
>
> Pete
>
> -----Original Message-----
> From: Talon Wolles [mailto:ta_iwo@y...]
> Sent: Wednesday, January 29, 2003 7:22 PM
> To: professional vb
> Subject: [pro_vb] Accessing a memo field
>
>
> Hi everyone.
>
> I am coding in VB6 using Access2000 as the database.
>
> There is a memo field type in Access. Having created
> this field in my table, how do I access the field in
> VB6 i.e. write to the field or read  the field.
>
> -Talon
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com