Discussions

Expand all | Collapse all

My formula text field does not recognize any spacing

  • 1.  My formula text field does not recognize any spacing

    Posted 03-26-2018 18:38
    I've created a formula text field to change the font color of another field (formula below).  Special Notes is the field I enter the information into and Special Notes Text is the formula field that pulls the text from the Special Notes field. 

    "<span style=\"color:red\">"& [Special Notes]&"</span>"

    It is working for the font color however none of the spacing, returns, etc. that I enter into the field are showing up when I view the field on a report.  Is there something I can add to my formula to keep the spacing or another formula I should be using that will do both?  Below is an example of what I'm experiencing.  Any help is appreciated!

    Text Entry Field in Edit Mode
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1719480/RackMultipart20180326-91956-1um4nzx-Notes_Spacing_inline.png?1522089266">


    Formula Field on Report


  • 2.  RE: My formula text field does not recognize any spacing

    Posted 03-26-2018 21:05
    Two things you might try.
    (1) confirm they are both 'rich text' type fields
    and 
    (2) try using a <div as opposed to a <span