CODEWITHSUNDEEP
ms-access
Peter
Peter

Reputation: 589

Access: How to insert a new line under control source for a text box?

I have two pieces of information which I would like to display together in one (not two) text box but in different lines on a report, e.g.:

FirstName
LastName

To have both information in one line I could use something like that under control source of the text box:

[FirstName] & " " & [LastName]

But by what do I need to substitute " " to get into a new line?

Thanks for help.

Upvotes: 0

Views: 504

Answers (1)

Harun24hr
Harun24hr

Reputation: 37050

Use below expression.

=[FirstName] & Chr(13)+Chr(10) & [LastName]

Upvotes: 1

Related Questions