Inserting in a text box a text with 3000 characters

[Guest]

I would like to insert in a text box a text with 3000 characters. The problem
is that i get an error every time i try to write more thn 255 chars. Is there
any hint for this? Also is it possible to use a label with the above text
size?

Thank You!!!

 

[Douglas J. Steele]

Is the textbox bound to a text field in a table? Text fields are limited to
255 characters. Change the field to a Memo to get by that limitation.

 

[Guest]

No there isn't. It's only a form with a textbox in it. I want the form to
display the same text on every open and the size of it is 3000 chars.

 

[PC User]

Is the textbox bound to a text field in a table? Text fields are limited to
255 characters. Change the field to a Memo to get by that limitation.

Doug,

What is the content limit for a memo field? I've copy & pasted
some very large documents into some memo fields and I've gotten a
limit error. It's been a while since I've done it and I can't
remember the error message, but it did truncate the end of the
document. At one point I was looking for a way to concatenate memo
fields, but no one knew if it was possible. Do know if it can be
done?

Thank,
PC

 

[Douglas J. Steele]

In one part of the Help file, it says a Memo field can store up to 64,000
characters. However, in other parts it says it can exceed that limit if you
use AppendChunck.

 

[Douglas J. Steele]

How are you trying to assign the value?

 

[Douglas J. Steele]

Where are you copying the text from?

What happens if you paste it into Notepad instead of Access: do you get
everything?

 

[Guest]

Doug,

I'm copying the text from Microsoft Word 2003. I copied it into Notepad as
you wanted and i get everything.

 

[Douglas J. Steele]

Sorry, but I can't think of any reason why you shouldn't be able to paste it
into a text box.