By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Data type STRING?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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?
Nov 12 '05 #2

P: n/a
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?

Nov 12 '05 #3

P: n/a
"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
Nov 12 '05 #4

P: n/a
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

Nov 12 '05 #5

P: n/a
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?
Nov 12 '05 #6

P: n/a
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
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.