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

Maximum bytes that can be stored in a string variable?

P: n/a
Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?
Nov 13 '05 #1
Share this Question
Share on Google+
15 Replies


P: n/a
On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:

Very large, but in my testing strangely unpredictable. I expected 2^32
- 1, but that was not the case.

Here is the test code I ran:
Sub Test()
Dim s As String
Const EXPONENT As Integer = 28
s = String$(2 ^ EXPONENT - 1, 65)
Debug.Print EXPONENT, Len(s)
End Sub

For values of EXPONENT greater than 28 I received an Out Of String
Space error. Still, at least 268 million characters - hopefully that's
enough?

-Tom.

Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?


Nov 13 '05 #2

P: n/a
Lauren Wilson <???@???.com> wrote in news:hs4jh01gq54kg2nn61pl0u3qdoma2m90qa@
4ax.com:
Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?


42

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.
Nov 13 '05 #3

P: n/a
"A variable-length string can contain up to approximately 2 billion
characters."
That's 2 Gigabyte. I don't know what happens with Unicode.

(david)

"Lauren Wilson" <???@???.com> wrote in message
news:hs********************************@4ax.com...
Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?

Nov 13 '05 #4

P: n/a

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:

Very large, but in my testing strangely unpredictable. I expected 2^32
- 1, but that was not the case.

Here is the test code I ran:
Sub Test()
Dim s As String
Const EXPONENT As Integer = 28
s = String$(2 ^ EXPONENT - 1, 65)
Debug.Print EXPONENT, Len(s)
End Sub

For values of EXPONENT greater than 28 I received an Out Of String
Space error. Still, at least 268 million characters - hopefully that's
enough?

-Tom.

Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?


Nov 13 '05 #5

P: n/a
On Wed, 11 Aug 2004 15:56:46 +1000, "david epsom dot com dot au"
<david@epsomdotcomdotau> wrote:
"A variable-length string can contain up to approximately 2 billion
characters."
That's 2 Gigabyte. I don't know what happens with Unicode.
Exactly what IS Unicode? I've never understood it.
(david)

"Lauren Wilson" <???@???.com> wrote in message
news:hs********************************@4ax.com.. .
Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?


Nov 13 '05 #6

P: n/a
> Very large, but in my testing strangely unpredictable.
Yes
I expected 2^32 No: 2^31
For values of EXPONENT greater than 28 I only get 27 on my PC - but that takes my total memory utilisation
to up around [Physical Memory] + [Page File], and even then I don't
get instantaneous memory release when the variable goes out of scope,
so I have to wait before I try it again. Of course, using my hard
disk for memory slows things down a bit, so I don't plan to use this
for anything anytime soon even if I can get 2^31 :~).

(david)

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:dq********************************@4ax.com... On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:

Very large, but in my testing strangely unpredictable. I expected 2^32
- 1, but that was not the case.

Here is the test code I ran:
Sub Test()
Dim s As String
Const EXPONENT As Integer = 28
s = String$(2 ^ EXPONENT - 1, 65)
Debug.Print EXPONENT, Len(s)
End Sub

For values of EXPONENT greater than 28 I received an Out Of String
Space error. Still, at least 268 million characters - hopefully that's
enough?

-Tom.

Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?

Nov 13 '05 #7

P: n/a
Unicode is a standard for text that supports alphabets
and character sets other than English. It may use 2
Bytes per character, in which case it may take up more
space than an English-only encoding like ANSI or ASCII,
(equivalently, you may be able to store less text in the
same space).

Before you store non-English alphabets in a Jet database,
you should tell Access what kind of alphabet and which
font you wish to use. Later, when you wish to view the
data, Access and Windows will look for a compatible
font.

This is one way that you can use Sort Orders, Case Rules,
and Fonts that are very different from English, and Unicode
is the standard that MS supports.

(david)

"Lauren Wilson" <???@???.zip> wrote in message
news:gq********************************@4ax.com...
On Wed, 11 Aug 2004 15:56:46 +1000, "david epsom dot com dot au"
<david@epsomdotcomdotau> wrote:
"A variable-length string can contain up to approximately 2 billion
characters."
That's 2 Gigabyte. I don't know what happens with Unicode.


Exactly what IS Unicode? I've never understood it.
(david)

"Lauren Wilson" <???@???.com> wrote in message
news:hs********************************@4ax.com.. .
Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?

Nov 13 '05 #8

P: n/a
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically: 1
GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your needs
and, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com...

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:

Very large, but in my testing strangely unpredictable. I expected 2^32
- 1, but that was not the case.

Here is the test code I ran:
Sub Test()
Dim s As String
Const EXPONENT As Integer = 28
s = String$(2 ^ EXPONENT - 1, 65)
Debug.Print EXPONENT, Len(s)
End Sub

For values of EXPONENT greater than 28 I received an Out Of String
Space error. Still, at least 268 million characters - hopefully that's
enough?

-Tom.

Access 2K

dim MyStr as string

What is the maximum amount of text or bytes that this variable can
store? Does anyone know?

Nov 13 '05 #9

P: n/a

I suspected as much. You description below does provide a plausible
reason for this particular error. Thank you very much. I think it
sucks that a text box bound to a memo field cannot allow manual entry
of the full capacity of the memo field (allegedly 64 MB) but that's
the way it is so I will program accordingly.
On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically: 1
GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your needs
and, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com.. .

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
>On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:
>
>Very large, but in my testing strangely unpredictable. I expected 2^32
>- 1, but that was not the case.
>
>Here is the test code I ran:
>Sub Test()
>Dim s As String
>Const EXPONENT As Integer = 28
>s = String$(2 ^ EXPONENT - 1, 65)
>Debug.Print EXPONENT, Len(s)
>End Sub
>
>For values of EXPONENT greater than 28 I received an Out Of String
>Space error. Still, at least 268 million characters - hopefully that's
>enough?
>
>-Tom.
>
>
>>Access 2K
>>
>>dim MyStr as string
>>
>>What is the maximum amount of text or bytes that this variable can
>>store? Does anyone know?


Nov 13 '05 #10

P: n/a
Hi, Lauren.

You're welcome. The bright side is that your hard work in coding a solution
to the 64 KB limit will probably help prevent future database corruptions
commonly caused by bound Memo fields.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"Lauren Wilson" <???@???.zip> wrote in message
news:4u********************************@4ax.com...

I suspected as much. You description below does provide a plausible
reason for this particular error. Thank you very much. I think it
sucks that a text box bound to a memo field cannot allow manual entry
of the full capacity of the memo field (allegedly 64 MB) but that's
the way it is so I will program accordingly.
On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically: 1GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your needs
and, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com.. .

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:

>On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:
>
>Very large, but in my testing strangely unpredictable. I expected 2^32
>- 1, but that was not the case.
>
>Here is the test code I ran:
>Sub Test()
>Dim s As String
>Const EXPONENT As Integer = 28
>s = String$(2 ^ EXPONENT - 1, 65)
>Debug.Print EXPONENT, Len(s)
>End Sub
>
>For values of EXPONENT greater than 28 I received an Out Of String
>Space error. Still, at least 268 million characters - hopefully that's
>enough?
>
>-Tom.
>
>
>>Access 2K
>>
>>dim MyStr as string
>>
>>What is the maximum amount of text or bytes that this variable can
>>store? Does anyone know?

Nov 13 '05 #11

P: n/a
Lauren Wilson <???@???.zip> wrote in news:4u9nh0lkf959m7jo6olncl1u3ru06t2utm@
4ax.com:
I suspected as much. You description below does provide a plausible
reason for this particular error. Thank you very much. I think it
sucks that a text box bound to a memo field cannot allow manual entry
of the full capacity of the memo field (allegedly 64 MB) but that's
the way it is so I will program accordingly.


If I were programming such blobs of text I think I would create, save them as
file entities, possibly word documents, and use the ado - indexing service
duo to manage them. This is very powerful; using indexing services searching
capabilities and catalogs can produce remarkable results, instantly.
--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.
Nov 13 '05 #12

P: n/a
Hi folks,

In light of the info below, does anyone know if the limits on editable
characters in a memo field bound to a text box has been improved in
Access 2003?

On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically: 1
GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your needs
and, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com.. .

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
>On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:
>
>Very large, but in my testing strangely unpredictable. I expected 2^32
>- 1, but that was not the case.
>
>Here is the test code I ran:
>Sub Test()
>Dim s As String
>Const EXPONENT As Integer = 28
>s = String$(2 ^ EXPONENT - 1, 65)
>Debug.Print EXPONENT, Len(s)
>End Sub
>
>For values of EXPONENT greater than 28 I received an Out Of String
>Space error. Still, at least 268 million characters - hopefully that's
>enough?
>
>-Tom.
>
>
>>Access 2K
>>
>>dim MyStr as string
>>
>>What is the maximum amount of text or bytes that this variable can
>>store? Does anyone know?


Nov 13 '05 #13

P: n/a
Hi, Lauren.

The limits are due to constraints of the Jet architecture. Since Access
2003 also uses Jet 4.0, these constraints have not changed since the Access
2K version. The maximum limits for a memo field are still 65,535 characters
entered into a text box and 1 GB when the characters are entered into the
field programmatically.

And the prevalence of database corruption due to bound memo fields is just
as great in Access 2003 as it was in Access 2K. I strongly suggest that you
unbind the memo field on your bound form. You'll get two benefits: less
likelihood of corruption and the ability to paste up to 1 GB of text into
the text box on a form.

And if you take Lyle Fairfield's suggestion to first save the text as files,
then use ADO and indexing services to connect to them, you'll receive other
benefits as well, including a much smaller database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Lauren Wilson" <???@???.???> wrote in message
news:sh********************************@4ax.com...
Hi folks,

In light of the info below, does anyone know if the limits on editable
characters in a memo field bound to a text box has been improved in
Access 2003?

On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically: 1GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your needs
and, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com.. .

That should be plenty. I thought maybe running out of string space
was causing the error I'm getting from pasting about 200K characters
into a text box bound to a memo field. When I arrive on such records
and place the cursor into the text box, I get a message that says
"text too large to be edited".

Any clues?
On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
<no*************@cox.net> wrote:

>On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:
>
>Very large, but in my testing strangely unpredictable. I expected 2^32
>- 1, but that was not the case.
>
>Here is the test code I ran:
>Sub Test()
>Dim s As String
>Const EXPONENT As Integer = 28
>s = String$(2 ^ EXPONENT - 1, 65)
>Debug.Print EXPONENT, Len(s)
>End Sub
>
>For values of EXPONENT greater than 28 I received an Out Of String
>Space error. Still, at least 268 million characters - hopefully that's
>enough?
>
>-Tom.
>
>
>>Access 2K
>>
>>dim MyStr as string
>>
>>What is the maximum amount of text or bytes that this variable can
>>store? Does anyone know?

Nov 13 '05 #14

P: n/a
Ron
And where might "Lyle Fairfield's suggestion to first save the text as
files..." be found?

TIA
ron

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:yDI2d.442$je.99@trnddc04...
Hi, Lauren.

The limits are due to constraints of the Jet architecture. Since Access
2003 also uses Jet 4.0, these constraints have not changed since the Access 2K version. The maximum limits for a memo field are still 65,535 characters entered into a text box and 1 GB when the characters are entered into the
field programmatically.

And the prevalence of database corruption due to bound memo fields is just
as great in Access 2003 as it was in Access 2K. I strongly suggest that you unbind the memo field on your bound form. You'll get two benefits: less
likelihood of corruption and the ability to paste up to 1 GB of text into
the text box on a form.

And if you take Lyle Fairfield's suggestion to first save the text as files, then use ADO and indexing services to connect to them, you'll receive other benefits as well, including a much smaller database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Lauren Wilson" <???@???.???> wrote in message
news:sh********************************@4ax.com...
Hi folks,

In light of the info below, does anyone know if the limits on editable
characters in a memo field bound to a text box has been improved in
Access 2003?

On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:
Hi, Lauren.

You are trying to paste too much into the text box. Access 2K has two
limits on Memo field size:

1.) Maximum number of characters when data is entered through the user
interface: 65,535.
2.) Maximum number of characters when data is entered programmatically:
1
GB.

You can find these limits, as well as others, by entering the word
specifications in Access 2K help.

Also, a known cause of Access database corruption is Memo fields being
edited through bound text boxes. Using VBA code to input the 200K
characters from the text box into the record will accommodate your

needsand, hopefully, prevent database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"VRWC" <???@???.zip> wrote in message
news:jf********************************@4ax.com.. .
>
> That should be plenty. I thought maybe running out of string space
> was causing the error I'm getting from pasting about 200K characters
> into a text box bound to a memo field. When I arrive on such records
> and place the cursor into the text box, I get a message that says
> "text too large to be edited".
>
> Any clues?
>
>
> On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
> <no*************@cox.net> wrote:
>
> >On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote:> >
> >Very large, but in my testing strangely unpredictable. I expected 2^32> >- 1, but that was not the case.
> >
> >Here is the test code I ran:
> >Sub Test()
> >Dim s As String
> >Const EXPONENT As Integer = 28
> >s = String$(2 ^ EXPONENT - 1, 65)
> >Debug.Print EXPONENT, Len(s)
> >End Sub
> >
> >For values of EXPONENT greater than 28 I received an Out Of String
> >Space error. Still, at least 268 million characters - hopefully that's> >enough?
> >
> >-Tom.
> >
> >
> >>Access 2K
> >>
> >>dim MyStr as string
> >>
> >>What is the maximum amount of text or bytes that this variable can
> >>store? Does anyone know?
>


Nov 13 '05 #15

P: n/a
Hi, Ron.

Lyle's suggestion is currently in "Message 7" of this thread of messages:

http://groups.google.com/groups?hl=e...3c87845a1612c1

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Ron" <ro*******************@earthlink.com> wrote in message
news:oE****************@newsread3.news.pas.earthli nk.net...
And where might "Lyle Fairfield's suggestion to first save the text as
files..." be found?

TIA
ron

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in message news:yDI2d.442$je.99@trnddc04...
Hi, Lauren.

The limits are due to constraints of the Jet architecture. Since Access
2003 also uses Jet 4.0, these constraints have not changed since the

Access
2K version. The maximum limits for a memo field are still 65,535

characters
entered into a text box and 1 GB when the characters are entered into the
field programmatically.

And the prevalence of database corruption due to bound memo fields is just as great in Access 2003 as it was in Access 2K. I strongly suggest that

you
unbind the memo field on your bound form. You'll get two benefits: less likelihood of corruption and the ability to paste up to 1 GB of text into the text box on a form.

And if you take Lyle Fairfield's suggestion to first save the text as

files,
then use ADO and indexing services to connect to them, you'll receive

other
benefits as well, including a much smaller database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Lauren Wilson" <???@???.???> wrote in message
news:sh********************************@4ax.com...
Hi folks,

In light of the info below, does anyone know if the limits on editable
characters in a memo field bound to a text box has been improved in
Access 2003?

On Thu, 12 Aug 2004 09:44:13 GMT, "'69 Camaro"
<Bl********************@Spameater.org> wrote:

>Hi, Lauren.
>
>You are trying to paste too much into the text box. Access 2K has two >limits on Memo field size:
>
>1.) Maximum number of characters when data is entered through the user >interface: 65,535.
>2.) Maximum number of characters when data is entered

programmatically:
1
>GB.
>
>You can find these limits, as well as others, by entering the word
>specifications in Access 2K help.
>
>Also, a known cause of Access database corruption is Memo fields being >edited through bound text boxes. Using VBA code to input the 200K
>characters from the text box into the record will accommodate your

needs >and, hopefully, prevent database corruption.
>
>HTH.
>
>Gunny
>
>See http://www.QBuilt.com for all your database needs.
>See http://www.Access.QBuilt.com for Microsoft Access tips.
>
>
>"VRWC" <???@???.zip> wrote in message
>news:jf********************************@4ax.com.. .
>>
>> That should be plenty. I thought maybe running out of string space
>> was causing the error I'm getting from pasting about 200K characters >> into a text box bound to a memo field. When I arrive on such records >> and place the cursor into the text box, I get a message that says
>> "text too large to be edited".
>>
>> Any clues?
>>
>>
>> On Tue, 10 Aug 2004 20:59:55 -0700, Tom van Stiphout
>> <no*************@cox.net> wrote:
>>
>> >On Tue, 10 Aug 2004 22:35:29 -0500, Lauren Wilson <???@???.com> wrote: >> >
>> >Very large, but in my testing strangely unpredictable. I expected 2^32 >> >- 1, but that was not the case.
>> >
>> >Here is the test code I ran:
>> >Sub Test()
>> >Dim s As String
>> >Const EXPONENT As Integer = 28
>> >s = String$(2 ^ EXPONENT - 1, 65)
>> >Debug.Print EXPONENT, Len(s)
>> >End Sub
>> >
>> >For values of EXPONENT greater than 28 I received an Out Of String
>> >Space error. Still, at least 268 million characters - hopefully that's >> >enough?
>> >
>> >-Tom.
>> >
>> >
>> >>Access 2K
>> >>
>> >>dim MyStr as string
>> >>
>> >>What is the maximum amount of text or bytes that this variable can >> >>store? Does anyone know?
>>
>



Nov 13 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.