Removing spaces between fields

[Nodge]

I have a simple database of names and addresses with separate fields for the
first and last names. I want to design a report which includes printing the
first name followed by the last name with just a single space between them
but I can't see how to do it.
TIA
Nodge

 

[James Arnold]

Bind the following to a text box:

=[FirstName] & " " & [LastName]

Where [FirstName] and [LastName] are the fields.

 

[Nodge]

Many thanks James.

Regards
Nodge

Bind the following to a text box:

=[FirstName] & " " & [LastName]

Where [FirstName] and [LastName] are the fields.

--
James

I have a simple database of names and addresses with separate fields for the
first and last names. I want to design a report which includes printing the
first name followed by the last name with just a single space between them
but I can't see how to do it.
TIA
Nodge