Textbox too short

[G37Sam]

Is there a way to increase the maximum allowed characters on an unbound textbox?

 

[vbaInet]

I don't remember seeing a limit in an unbound textbox. What limit are you experiencing?

 

[G37Sam]

I keep getting this error:

"The text is too long to be edited"

Everytime I paste long html code into a textbox.

 

[vbaInet]

That's the sort of error message I would expect to see in a bound textbox for a Text data type. Can you upload a sample db with a textfile containing the text you're copying and pasting into it?

 

[G37Sam]

Well, view the HTML Source of this page for example, copy it and paste it in an unbound textbox in a form and see what error you get.

 

[vbaInet]

Works fine for me.

 

[G37Sam]

Strange.. Can you do it here:

View attachment New Microsoft Office Access 2007 Database.accdb

 

[vicsar]

I keep getting this error:

"The text is too long to be edited"

Everytime I paste long html code into a textbox.

G37SAM, I suggest you look at your tables and not the forms. Which field on what table are you updating? Go to the tables in edit mode and look at the field, if the Data Type is Text you can increase the field size up to 255 characters; however, it looks like you might need to use a Memo Data Type. Be careful when use this Data Type there are certain limitations in the amount of text you are able to export to Excel, for instance.

This is from the Access 2003 Help File:
Setting
Text

Type of data
(Default) Text or combinations of text and numbers, as well as numbers that don't require calculations, such as phone numbers

Size
Up to 255 characters or the length set by the FieldSize property, whichever is less. Microsoft Access does not reserve space for unused portions of a text field.

Setting
Memo

Type of data
Lengthy text or combinations of text and numbers.

Size
Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.)

I hope this helps you.

 

[G37Sam]

I tried both, setting the field to unbound (no need for table) AND linking it to a MEMO field. Both yielded the same error.

 

[vbaInet]

I forgot to mention that I set the Text Format to Rich Text that's why it worked.

But yes you are limited to 65, 535 characters like vicsar mentioned. Unbound textbox with a Rich Text format or a textbox bound to a Memo field both have the same limit.

 

[G37Sam]

I forgot to mention that I set the Text Format to Rich Text that's why it worked.

But yes you are limited to 65, 535 characters like vicsar mentioned. Unbound textbox with a Rich Text format or a textbox bound to a Memo field both have the same limit.

That is what I have already established sir.

My question is, is there anyway to increase that limit?

What about a string variable? Does that have an upper limit too? Maybe I'll just save long strings in a .txt file and import it using vba?

 

[vbaInet]

Not that I know of. It's a limit and these kind of limits usually don't have workarounds.

A string variable can hold a heck of a lot, something in the region of 1 to 2 billion characters (not sure exactly). But how do you get your text to a variable without going through a textbox? The office clipboard perhaps.

Your users should make any changes that they want to make in a different application then copy it across.

 

[RainLover]

There is something wrong with the Form or Text box.

I can copy past as much as I like in my sample DB.

Would need to see a Sample of yours.

If you could post a DB with the error in Access 2003 then we may be able to find something.

 

[G37Sam]

I already posted it in post #7, check it out.

 

[RainLover]

I already posted it in post #7, check it out.

I realise that but I was looking for a 2003 Version as per my post

Thanks

 

[G37Sam]

Oh my bad, I was under the impression it was 2012 and everyone had a version of 2007 around them haha

Here's a screenshot of an mdb I just created. Literally, all I did was create it, new form, blank text box, paste and BAM!

Here's the DB:

View attachment Database1.mdb

 

[RainLover]

There is something wrong with the Form or Text box.

I can copy past as much as I like in my sample DB.

Would need to see a Sample of yours.

If you could post a DB with the error in Access 2003 then we may be able to find something.

Mine started to work but now it does not.

Sorry but I have been of no help.