text too long to edit

[rccline]

I am trying to paste text into a textbox on a report. The text contains about 20 lines of 8 point text. Access will not allow that much text into the textbox. I get the error message "text too long to edit."

Rather than doing a mailmerge with MSWord, I am trying to create muliple page "report" in Access.

Is there a way to set the values for the text box so it will accept more lines of text?

Thanks,

Robert

 

[scriverb]

Robert, you could set the text box Can Grow property to Yes. This way the text will wrap around and the textbox will size will get taller and move down your report when needed only.

I am not sure if this is the complete answer to your question but try this first. Bob Scriver

 

[rccline]

That helps. Part of my error was that I was not using a textbox, but a label. The problem is, I have a long paragraph with variable fields [with variable length] within the paragraph. However, even the label would wrap differently on the report than it did in design view. This makes it difficult to manipulate label placement to acheive an even line flow and spacing on the report.

Perhaps the solution is something which is better suited by merging the data with MSWord. I was trying to do this within an Access report. What do you suggest?

Thank you.

Robert

 

[scriverb]

I guess I don't understand the use of a label for a large text string. But, you can through code control line wrapping somewhat by inserting carriage returns within the text. This requries some analysis of the text string through code and placing the carriage returns where they make the most sense.

Example:
vWholeString = assignment of string value
me![TextBoxName] = Mid$(vWholeString, 1,50) & vbCrLf & Mid$(vWholeString,51,50) & vbCrLf & Mid$(vWholeString,101,50) . . . to the end of string

This is just an exaple of cancatenating a carriage return to control the wrapping in a text box. I certainly would not use a label for this purpose. A TextBox with the Can Grow property is the way I have always approached this problem.

Does this help? Bob Scriver

 

[rccline]

Bob:

Your first reply convinced me that use of a label for this sort of thing was a bad idea. The option to merge the data through a query to MSWord is appearing to become a more practical idea although it would require more steps to complete the report.

I have something like this:

A long string of text which actually goes on for paragraph after paragraph with <<variable length fields>> interspersed within the text-string; these fields represent the fields of data that are to be inserted in the textstring. I need to generate a separate report for each record returned by the query. This is like a MailMerge in Word. I guess the question now is: Is it worth pursuing the attempt to use an Access report to accomplish this? Or, would you simply mailmerge each time you want to generate the &quot;reports?&quot;

Many thanks for your suggestions.

Robert

 

[scriverb]

I believe a MailMerge would be the most beneficial. That way you can certainly control the formatting of the page much easier. Question, is the text portion of your string the same for each record? If so then that portion of the mail merge should be hard coded into the Merge template in Word. Then you only have to perform the DDE link/merging of the dynamic data strings.

I have done just this type of thing recently with over 100 templates that are used daily by our field staff. The templates are setup in their predetermined formats and Mail Merge process is initiated where we have linked fields nested within the Word Document. Works out quite well.

Good luck with your project. Bob Scriver