>"Allstate" on the report, because their isn't enough space for the "Insurance". >I would like to have it print:
>
>"Allstate Insur" (or wherever we happen to run out of space).

In addition to the previous suggestions, you could consider establishing a field in the database that would hold the short company name which you would use to print. Thus Allstate insurance not only would always be Allstate Insur, but Prudential Insurance would always be Prudential Insur rather than Prudential Ins. A report using both insur and sometimes ins could be visually ugly, but it depends upon your audience.

If you don't want the user to maintain two names, you can blow your data into a temp dbf and then apply your rules to come up with a short name to use before you print.

My experience is, when practical, to do the database tweeking out of the report environment rather than trying to get the report to look correct with alot of iff() statements within fields.

I hate it when I deliver a report and they say 'gee this looks nice' rather than 'gee the data is great!'.