How can I add a linefeed to a text field?
I have been attempting to combine several notes fields when importing data and I am unable to find a way to insert them into the text field as multiple lines. I have tried using "\n", \n, '\n', LF, CRLF. None of these work. Any ideas?
2 replies
-
Tom
try line feed Char(10)
-
Otherwise - if you are regulary intending to import the same csv data. You could leave the orginal fields on the form (say tucked out of the way on another form tab)
and do 1 of 2 things
1) add a formula field (mergedText) then add a script to that formula filed 'notefield1' + "
" + 'notefield2' + "
" + 'notefield3' + " etc (see image and remember to press return key on each line (as shown)2) Or Create a text field (mergetextfield) for the merged data and add a button with the script such as. mergetextfield := 'notefield1' + "chr(10)" + 'notefield2' + "chr(10)" + etc etc
change above field names for yours
Content aside
- 3 yrs agoLast active
- 2Replies
- 340Views