String Returned By The Builder Was Too Long

[NMiller007]

I'm working on an automated letter report and one of the paragraphs is now giving me the "The string returned by the builder was too long. The result has been truncated." error.

What are some ways to get around this?

The paragraph consists of nested Iif statements that produce multiple sentence results. The paragraph has several common elements (the beginning and the end), but has portions that only appear when criteria are met.

I can't split it into multiple paragraphs, because I want it to be continous.

When I Googled this error, I found some mention of using a function to return the information. Would this be the best method?

 

[dhookom]

Try without using the builder. Otherwise, a function could be used to concatenate strings and variables together.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NMiller007]

I wasn't actually using the builder. I did use zoom though.

I ended up using a function and called the function as the control source of the text box.

Thanks for the reply.