Text Breaking

[jglassner]

Good morning all.

I am using the following string to combine first and last names.

=[Perfered Name] & " " & [Last Name]

However, my last name is breaking to a second line and I don't know why.

Any thoughts are welcome.

Jase

 

[63falcondude]

Wrap text is probably selected

 

[63falcondude]

Try shrinking the text or making the column larger.

 

[jglassner]

None of that worked should also mention that this is in the header of the report.

 

[63falcondude]

I didn't think you can use a formula in a header unless you are using VBA...

 

[jglassner]

Nope. Moved it to the body of the report, same thing.

 

[63falcondude]

Might be a stupid question but are you on excel? By the body, you mean where the cells are?