Report Text Box Force Line Carriage Return and Line Feed

[Dwade]

I set a text box on report to combine 3 fields.

EployId
FirstName
LastName

control is set
=[EmployId] & Chr(13) & Chr(10) & Left([FirstName],1) & ". " & [LastName]

so if information is
employId = 16-12345
FirstName=Jason
LastName=Johnson

I want it printed thusly on the report
16-12345
J. Johnson

I get 16-12345 J.
Johnson

but this is due to the field being set "can grow" yes

What am I doing wrong here?

 

[KC-Mass]

Hi Dwade,

The "Can Grow" setting on a form control allows it to grow verically, not
horizontally. If you are getting odd wrapping it is because the text box is
to small horizontally.

Regards

Kevin