I need to put a paragraph which will include customer name, address etc at the report footer.
the paragraph looks something like this:
some text in front...... + customer name + some text in middle + address 1 + address 2 + address 3 + some text at the end.
I use VBA to read customer name, address 1,2,3 etc and join them together with the "some text in front" "some text in middle" and "some text at the end" .
problem now is I need to span the entire final text paragraph nicely across the report / page width.
If I use RW Calculated field, there is a limit of 80 characters !!! and each line will appear rather short, not occupy the full page width and look odd...
beside calculated field, any other work around?
I read somewhere about using label instead, but can't figure out how.
or any other suggestion?
thanks.