Data type STRING?

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.

re: Data type STRING?

mbev wrote:
[color=blue]
> 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.
>
>[/color]

You mean 65,535? :-)

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

--
But why is the Rum gone?

re: Data type STRING?

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

"Trevor Best" <nospam@localhost> wrote in message
news:4080826e$0$23747$afc38c87@auth.uk.news.easyne t.net...[color=blue]
> mbev wrote:
>[color=green]
> > Is it possible to add more than 65,000 characters in a field in[/color][/color]
Microsoft[color=blue][color=green]
> > Access 2003? With the data type "MEMO" only let me add 65,000[/color][/color]
characters.[color=blue][color=green]
> > Thanks in advance.
> >
> >[/color]
>
> You mean 65,535? :-)
>
> That's a limitation of the textbox control, try an RTF control instead.
>
> --
> But why is the Rum gone?[/color]

re: Data type STRING?

"mbev" wrote
[color=blue]
> Could you please tell me how
> to try an RTF control?[/color]

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

re: Data type STRING?

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

"Larry Linson" <bouncer@localhost.not> wrote in message
news:Ta0gc.4118$L31.2707@nwrddc01.gnilink.net...[color=blue]
> "mbev" wrote
>[color=green]
> > Could you please tell me how
> > to try an RTF control?[/color]
>
> There's one in the Developer Edition of Office XP and earlier. I don't[/color]
have[color=blue]
> the Visual Studio.NET Tools for Office 2003 System to see if it is one of
> the ActiveX controls included. FMS, Inc., sells one[/color]
(http://www.fmsinc.com).[color=blue]
> MVP Stephen Lebans, http://www.lebans.com, has a free one on his website.
>
> Larry Linson
> Microsoft Access MVP
>
>[/color]

re: Data type STRING?

mbev wrote:
[color=blue]
> My question is if I can create a recorset with more than 65K character in
> Access 2003?
> Thanks[/color]

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?

re: Data type STRING?

Trevor Best <nospam@localhost> wrote in
news:4080a08f$0$6172$afc38c87@auth.uk.news.easynet .net:
[color=blue]
> mbev wrote:
>[color=green]
>> My question is if I can create a recorset with more than 65K
>> character in Access 2003?
>> Thanks[/color]
>
> There's no limit in VBA (well, 2GB or thereabouts), not sure about
> DAO or ADO, you might need search help for "appendchunk"[/color]

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