Text Boxes in a report

[nl]

I have three text boxes aligned horizontally.
How can I make them shrink if one of them doesn't have
data in it.
Example: Text1 Text2 Text3, if there's no
information in Text2, then Text3 should move over next to
Text1, e.g. Text1 Text3

Thank you.

 

[Les]

Could you combine the contents into 1 text box? Text box1
control source would look something like:

=Trim(Text1) & " " & Trim(Text2) & " " & Trim(Text3)

 

[fredg]

I have three text boxes aligned horizontally.
How can I make them shrink if one of them doesn't have
data in it.
Example: Text1 Text2 Text3, if there's no
information in Text2, then Text3 should move over next to
Text1, e.g. Text1 Text3

Thank you.

Concatenate them in one unbound control, using the + instead of the &
where indicated:

=[First Name] & " " & ([MiddleName]+" ") & [LastName]

John Robert Smith
Mark Wilson