Data type STRING?

[mbev]

Is it possible to add more than 65,000 characters in a field in Microsoft
Access 2003? With the data type "MEMO" only let me add 65,000 characters.
Thanks in advance.

[Trevor Best]

mbev wrote:

Is it possible to add more than 65,000 characters in a field in Microsoft
Access 2003? With the data type "MEMO" only let me add 65,000 characters.
Thanks in advance.

You mean 65,535? :-)

That's a limitation of the textbox control, try an RTF control instead.

--
But why is the Rum gone?

[mbev]

Could you please tell me how to try an RTF control?
Thanks a lot

"Trevor Best" <nospam@localhost> wrote in message
news:40***********************@auth.uk.news.easyne t.net...

mbev wrote:

Is it possible to add more than 65,000 characters in a field in Microsoft Access 2003? With the data type "MEMO" only let me add 65,000 characters. Thanks in advance.

You mean 65,535? :-)

That's a limitation of the textbox control, try an RTF control instead.

--
But why is the Rum gone?

[Larry Linson]

"mbev" wrote

Could you please tell me how
to try an RTF control?

There's one in the Developer Edition of Office XP and earlier. I don't have
the Visual Studio.NET Tools for Office 2003 System to see if it is one of
the ActiveX controls included. FMS, Inc., sells one (http://www.fmsinc.com).
MVP Stephen Lebans, http://www.lebans.com, has a free one on his website.

Larry Linson
Microsoft Access MVP

[mbev]

My question is if I can create a recorset with more than 65K character in
Access 2003?
Thanks

"Larry Linson" <bo*****@localhost.not> wrote in message
news:Ta*****************@nwrddc01.gnilink.net...

"mbev" wrote

> Could you please tell me how
> to try an RTF control?
There's one in the Developer Edition of Office XP and earlier. I don't

have the Visual Studio.NET Tools for Office 2003 System to see if it is one of
the ActiveX controls included. FMS, Inc., sells one (http://www.fmsinc.com). MVP Stephen Lebans, http://www.lebans.com, has a free one on his website.

Larry Linson
Microsoft Access MVP

[Trevor Best]

mbev wrote:

My question is if I can create a recorset with more than 65K character in
Access 2003?
Thanks

There's no limit in VBA (well, 2GB or thereabouts), not sure about DAO
or ADO, you might need search help for "appendchunk"

--
But why is the Rum gone?

[David W. Fenton]

Trevor Best <nospam@localhost> wrote in
news:40**********************@auth.uk.news.easynet .net:

mbev wrote:

My question is if I can create a recorset with more than 65K
character in Access 2003?
Thanks

There's no limit in VBA (well, 2GB or thereabouts), not sure about
DAO or ADO, you might need search help for "appendchunk"

But you can't use a memo field, right? You'll have to go with OLE?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc