Eliminating spaces in reports

  • Thread starter Thread starter L. Woodhouse
  • Start date Start date
L

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