Report Text Box Force Line Carriage Return and Line Feed

  • Thread starter Thread starter Dwade
  • Start date Start date
D

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?
 
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
 
Back
Top