Forcing Fields to Wrap

[klbsw15]

Hi,

I am working on a report which has address fields in it. I have got the
fields to wrap up if there isn't a field above, but I am struggling to force
them to do the same for the name fields...

Title First Last
Mr Joe Bloggs - this is fine
Joe Bloggs - in this example I want the fields to all move to the left

I hope that makes sense and someone can help!

Thanks

 

[fredg]

Hi,

I am working on a report which has address fields in it. I have got the
fields to wrap up if there isn't a field above, but I am struggling to force
them to do the same for the name fields...

Title First Last
Mr Joe Bloggs - this is fine
Joe Bloggs - in this example I want the fields to all move to the left

I hope that makes sense and someone can help!

Thanks

Use one unbound text control.
Set it's control source to:

=([Title] + " ") & [FirstName] & " " & [Lastname]

Make sure the name of this control is NOT the same as the name of any
field in the control source expression.