[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

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
0
Tom Knowlton
Asked:
Tom Knowlton
  • 6
  • 2
1 Solution
 
kenspencerCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now