Inserting in a text box a text with 3000 characters

  • Thread starter Stefanos_Karametos
  • Start date
S

Stefanos_Karametos

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!!!
 
D

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.
 
S

Stefanos_Karametos

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.
 
P

PC User

Douglas J. Steele said:
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
 
D

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.
 
D

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?
 
S

Stefanos_Karametos

Doug,

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

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.
 
Top