Forcing Fields to Wrap

  • Thread starter Thread starter klbsw15
  • Start date Start date
K

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
 
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
Click to expand...

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.
 
Back
Top