text box word spacing for postage

[Guest]

Im creating postcard type reports with names and addresses on each card.
here is an example of my problem;
1 textbox is persons 'initials' and the other textbox next to it, is their
'surname'.
I need the initial box to be able to expand and shrink when the initials are
longer or shorter so that the surname is spaced correctly after the initials,
for example;
'C Smith' would be one record, but then there is a 'M and K Smith', so in
the report, the C Smith looks like this 'C Smith' (too much space
between to allow for the longer words of 'M and K Smith'. )
The 'surname' box could also be a company name therefore the initial box
would be blank so i need the company name to shift over to the left of the
report to line up properly for postage reasons.
I have tried the Can shrink and grow options but it wont do anything!

 

[Allen Browne]

Use one text box that combines the initials and surname.
It's Control Source property will be something like this:
=Trim([initials] & " " & [surname])

Also, make sure the Name property of this text box is not the same as your
fields. (For example, it must not be named initials or surname.)

 

[Guest]

Perfect! thankyou, now that fixes alot of text boxes in this report wow!

Use one text box that combines the initials and surname.
It's Control Source property will be something like this:
=Trim([initials] & " " & [surname])

Also, make sure the Name property of this text box is not the same as your
fields. (For example, it must not be named initials or surname.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Im creating postcard type reports with names and addresses on each card.
here is an example of my problem;
1 textbox is persons 'initials' and the other textbox next to it, is their
'surname'.
I need the initial box to be able to expand and shrink when the initials
are
longer or shorter so that the surname is spaced correctly after the
initials,
for example;
'C Smith' would be one record, but then there is a 'M and K Smith', so in
the report, the C Smith looks like this 'C Smith' (too much space
between to allow for the longer words of 'M and K Smith'. )
The 'surname' box could also be a company name therefore the initial box
would be blank so i need the company name to shift over to the left of the
report to line up properly for postage reasons.
I have tried the Can shrink and grow options but it wont do anything!