Is there a way to left justify a concatenated formula?
I have a formula that combines three fields
{Contract} & ' ' & {Description} & ' ' & {Name}
the problem I am running into is that description varies in length
I am try to get the Name field left justified on the longest description
i.e.
contract description name
contract descr name
contract descript name
etc.
I have tried the following but I still cannot get the third field to be left justified off the longest description.
Formula A
{Description} + replicatestring (" ", 65 - len ({Description})) + {Name}
Formula B
{Contract} & ' ' & @FormulaA
Thanks in advance
Sorry I do not understand what you are trying to achieve, in the layout you have shown the third field is left justified.
when you concatenate the fields like this {Contract} & ' ' & {Description} & ' ' & {Name} they are automatically left justified relative to each other.
Please show us what you are getting and what you would like to achieve.
Ian