Trim space between fields

[rbolton]

We would like to be able to trim the space between fields in Access.

[JoeM]

Not sure you mean. There really aren't spaces between "fields".
Do you mean trim spaces between words within a single field in Access?
Or perhaps you are doing an export of the data?
A simple example may help illustrate exactly what you are after.

[rbolton]

I didn't explain my question as well as I should have.
When you print a form that has two adjacent fields, and the text in the first of the two fields is shorter than the field and you want the second field to print one space to the right of the first field, how do you tirm the space that is the extra space in the first field?

Thank you.

example: Bill Smith
(first field) ( second field)
trim this
space

[rpeare]

Have you tried concentenating your fields into a single variable?

For instance let's say you have a field FirstName and a field LastName where you want one space between first and last name you'd have a single text box with the formula

=[FirstName} & " " & [LastName]

[send2steph]

=[FirstName} & " " & [LastName]

Save your form as a report, then slightly change the report so that the fields are concatenated as suggested.
Fill in the form; print the report.

[rbolton]

I'm new to Access and don't know how to concentenate. I have never used that word in my vocabulary. Can you concentenate in forms? Do you have to copy the form into a report? Then, do you go back to a form to print?
I really appreciate the assistance.
Ross Bolton
I'm trying to eliminate the spaces in a field when printing to fields where the text does not use all the spaces and I would like the two texts to print with a single space between them. The example is a first and last name.

Thanks again.

[June7]

Assuming field names LastName, FirstName - an expression in textbox Control Source property or in a query would be like:

[LastName] & ", " & [FirstName]

The & character is preferred concatenation operator. However, be careful as the + character will also do concatenation in some cases.