Inserting text box between two labels

[BatmanMR287]

I need to have a line on a report says the word "For" before a name and "Only" after the name on the same line. The problem is spacing, the names will have different numbers of characters so how do I make it look like there is only one space between each word?

[June7]

Concatenate literal text and fields with expression in query or textbox ControlSource.

[BatmanMR287]

Can I get an example of the expression? And where do I put it in the query?

[June7]

In a query, put expression on Field row. This is constructing a field in query with expression.

"For " & [some field here] & " Only"

[BatmanMR287]

That works! I used the expression builder because the field is used in two other places on the report. I had to put it in like this. =[some field here] & " Comments Only". It looks like I could have just typed that into the textbox in design mode as well. Thanks June7.