I have a SQL statement which concatenates several fields and uses conditional IIF's to add formatting - but I find that VFP is truncating the results.

I figure VFP takes the result of one result to calculate the width of the result table, and additional rows are just a lot longer than that.

How can I get around this?

TIA