I am using calculated value field in an effort to produce a form in two languages, English and French.
I have a table with fields for both languages and the form loads in the data correctly.
I am using a drop down to specify which language to use.
All of this is working perfectly fine, however the formatting of the text with in the Calculated fields is awkward.
Most fields are ok, but when a field has text that fills more then one line I believe it justifies the text for an unknown reason.
I have used the text alignment tools along the ribbon to try and left align and center where needed. This works in the preview mode of the form from within the editor, but in the published form in the live list it does not work.
Is there any way I can control the formatting of text within a calculated field?
Thanks in advance, please let me know if there's any further information I can provide.