Can I use the TRIM function with a bound control in an Access report?

[ivalum21]

I am making an Access report...in this report I have a section that lists a person's First Name, Last Name, Address, City, State, Zip.

Is there a way I can apply a trim function to those bound controls, so I don't have to worry about there being a lot of space between someone's first and last names given how long their name is??

Example:

What is looks like now...
Steve Smith
Benjamin Jones

What I want it to look like...
Steve Smith
Benjamin Jones

 

[jrbarnett]

Yes:

Set the ControlSource to

=Trim([Firstname]) & " " & Trim ([Lastname])

John

 

[ivalum21]

Do I change it in the Properties > Data > Control Source?? Because when I change it there, I get an error...

 

[jrbarnett]

What are the actual names of the fields?

These must be enclosed in the square brackets.

John