Eliminating spaces in reports

[L. Woodhouse]

How do I eliminated a space between fields on report.

EG. Lesley Woodhouse
change it to Lesley Woodhouse where the first field name is
not always going to contain the same number of characaters.

 

[Cheryl Fischer]

Create a new Text Box control on your report, replacing the text boxes for
first name and last name. Name this new Text Box something like:
txtFullName (or any name so long as it is not the same as a field name in
your report's underlying record source). In the Control Source property of
your new Text Box, enter the following:

=trim([FirstName]) & " " & trim([LastName])

Of course, substitute your actual field names for FirstName and Last Name.

hth,