split field in report, leave together in field

[prairiewind via AccessMonster.com]

I have a contact database, from which I print a booklet for my customers.
However, I ran into a problem where one field (Children) sometimes gets to
long and the field grows. This results in the adjacent field in the report
to skip a line. What I'm wondering is if there is a way to split the data in
a field so that it prints on two lines, but leave the data only in one field.
The reason I don't want to make two fields is that I need all the information
together for other reports.

What I'm needing is to split the Children field if it is over a certain
length. Then take the first part and print it on one line and then print the
second part on the second line. Otherwise, if the Children field is under a
certain length, publish it all one one line.

Thanks, Jeffrey

 

[KARL DEWEY]

If you do not need to split at any special point then try this --
IIF(Len([Field1] > 15, Left([Field1], 10) & Chr(13) & Chr(10) &
Mid([Field1], 11), Field1)
15 is the test point to split or not.