Large amount of text

I have a large amount of text I want to paste into a control on a MS Access form.

I've tried using a text box, but I get a message saying:

"The text is too long to be edited"

Apparently the text box has some unknown limit to the amount of text it can hold?

So, is there another control I can use?

OR

Will I have to save the desired info into a file and open and parse the text file?

I am looking for easy here.

My objective is to take the web page source and parse it to extract useful information from it, etc.

Thanks,

Tom
LVL 5
Tom KnowltonWeb developerAsked:
Who is Participating?
 
kenspencerConnect With a Mentor Commented:
Hi,

If your text box is bound to a memo field, the text should fit.  What is the target text box bound to?

Ken
0
 
Tom KnowltonWeb developerAuthor Commented:
Good point!

The text field is unbound.

I tried binding it to a Memo filed just now...no dice!

Darn...thought for sure that would work!
0
 
Tom KnowltonWeb developerAuthor Commented:
About the most I could paste into the memo field was something like 44 KB.

Hmmmm....
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Tom KnowltonWeb developerAuthor Commented:
Yeah...I looked it up and the max chars in a Memo is:

64,000 chars

My text going into the Memo is a whopping:

97,540 (including spaces)

Is there anything larger than a Memo field?
0
 
Tom KnowltonWeb developerAuthor Commented:
With the spaces removed, the text I am importing is still:  67,000 plus chararcters.
0
 
Tom KnowltonWeb developerAuthor Commented:
Looks like binding the field to a Memo field is the answer I will pursue for now.

Thanks!
0
 
kenspencerCommented:
Hi,

Got busy and could not get back to you.  You want to copy/paste 97k?  Seems like you will have to split it into two pieces to get it all.  Higher end databases (Oracle, SQL Server, etc.) may handle it all in one chunk though; I don't know for sure though.

Good luck.

Ken
0
 
Tom KnowltonWeb developerAuthor Commented:
Okay.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.