BR() tag in default value formula of a text area (long) field not working

Question

I have a text area (long) field. It contains the default value "Text1" & BR() & "Text2".

It never renders the br() tag correctly, the final result is always 'text1 BR() text2'. Field type is text area(long). Setup to display 2 lines.

What am I doing wrong here? I've tried both "text1" & BR() & "Text2" and "Text1"&BR()&"Text2". And according to the documentation it should work.

Nope, it's just a default formula value for a text field. No apex involved.
How do you show the text, where is it broken? At custom vf-page or on the standard layout page?
I just tested your code "Text1" & BR() & "Text2" for an account object and it works fine for me. At the account creation standard page i can see an input text (long) with Text1 and Text2 with brake in between.

user320 · Accepted Answer · 2013-02-20 13:36:30Z

up vote 3 down vote accepted

Try using + instead of &?

answered Feb 20 at 13:36

user320
3,7201221

1

the +did the trick. Thanks @user31! FWIW - this was on standard page layout. No Visualforce at all. – akarnid Feb 21 at 14:56

woop woop! what you did appears to be fully supported - wanna raise a Case? – user320 Feb 21 at 16:36

Jesse Altman · Answer 2 · 2013-02-20 13:27:31Z

up vote 2 down vote

If you are using this formula field on a Visualforce page with an apex:outputText try using the escape attribute.

So, something like:

<apex:outputText value="{!Custom_Object__c.Custom_Formula_Field__c}" escape="false"/>

answered Feb 20 at 13:27

Jesse Altman
4,714436

2 Answers