New Line in Calculated TextBox

[DeanWilliams]

Hi,

I have a TextBox that I want to put a 2 line Calculation in:
ControlSource:

=[Imperial] & "ft²" & Chr(13) & Format([Imperial]*0.0929,"Fixed") & "m²"

It shows up as that square symbol instead of a new line. How can I do what I want? I have tried using vbCr and Chr(10).

None work.

Thanks in advance,
Dean.

 

[CajunCenturion]

Try using the symbolic constant: vbCrLf

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[RoyVidar]

I think if you try both chr(13) and chr(10), you need both, and in that order for controlsources.

Roy-Vidar