removing white space in a row

[Zalthu]

I want to concatenate 3 fields in a report header so that the space between
different sized textboxes is eliminated. For Example:
Title FirstName LastName

Some names are longer than others but I want to reduce the space between
FirstName and Last Name to about one character space without spilling over
onto the next field

I have found lots about removing white space in rows but not much linearly.
I used to do something similar in Delphi by, if my memory serves me
correctly, putting all the three fields inside another text control with the
properties set to grow and shrink. can't remember the details though.

Any ideas?

 

[Allen Browne]

Use a text box with Control Source of:
=Trim([Title] & " " & [FirstName] & " " & [LastName])

Make sure the Name of this text box is not the same as your fields. For
example, it must not be called Title.

 

[Zalthu]

Thanks Allan that will do the trick nicely but, if you don't mind me asking,
what are you doing up in the middle of the night in Australia.

Ian Milward
Edinburgh

Use a text box with Control Source of:
=Trim([Title] & " " & [FirstName] & " " & [LastName])

Make sure the Name of this text box is not the same as your fields. For
example, it must not be called Title.

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

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

I want to concatenate 3 fields in a report header so that the space
between different sized textboxes is eliminated. For Example:
Title FirstName LastName

Some names are longer than others but I want to reduce the space between
FirstName and Last Name to about one character space without spilling
over onto the next field

I have found lots about removing white space in rows but not much
linearly. I used to do something similar in Delphi by, if my memory
serves me correctly, putting all the three fields inside another text
control with the properties set to grow and shrink. can't remember the
details though.

Any ideas?

 

[Allen Browne]

That's when people post the questions.

UK comes on-line around 4pm our local time, and US typically around 11pm.

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

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

Thanks Allan that will do the trick nicely but, if you don't mind me
asking, what are you doing up in the middle of the night in Australia.

Ian Milward
Edinburgh

Use a text box with Control Source of:
=Trim([Title] & " " & [FirstName] & " " & [LastName])

Make sure the Name of this text box is not the same as your fields. For
example, it must not be called Title.

I want to concatenate 3 fields in a report header so that the space
between different sized textboxes is eliminated. For Example:
Title FirstName LastName

Some names are longer than others but I want to reduce the space between
FirstName and Last Name to about one character space without spilling
over onto the next field

I have found lots about removing white space in rows but not much
linearly. I used to do something similar in Delphi by, if my memory
serves me correctly, putting all the three fields inside another text
control with the properties set to grow and shrink. can't remember the
details though.