How to make line break in Text Expression in a Text Box

[taha_mansoor]

Hi,

I need to give a line break inside the text expression i.e. ='Medicine Bulk:'& Num(Sum(Med.Bulk), '#,##0') . How to make it possible ?. Screen shot is attached for reference.

Thanks

Taha

[taha_mansoor]

Clarifying it more, I need the output to be appeared like concatenated text to be displayed on top of the expression value.

[sunny_talwar]

Try Chr(10) & Chr(13) may be like this:

='Medicine Bulk:' & Chr(10) & Chr(13) & Num(Sum(Med.Bulk), '#,##0')

[karolina_]

Try
='Medicine Bulk:\n'& Num(Sum(Med.Bulk), '#,##0') .

[Peter_Cammaert · Accepted solution]

Chr(10) (aka Line Feed or more appropriately NewLine) will do. Like in

='Medicine Bulk:' & Chr(10) & Num(Sum(Med.Bulk), '#,##0')

Chr(13) is not needed anymore. We've left behind the times of carriages (and typewriters)

Peter

[taha_mansoor]

Thanks all for the help.