Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a question on how to left align the text in input box when importing directly from external source? As of now the text is appearing in the form of paragraph but want to present it in line breaks? I don't see any option in Input box properties for alignment?
Thanks,
Varun
Thanks Anjos but Can we apply something similar in Text box also?
Thanks Anjos but Can we apply something similar in Text box also?
Yes, it looks differently - see tab General, section Layout (in the middle) - Horizontal and Vertical alignments
Thanks Michael.But still not able to do line break.
Current Output: 1.aaaaaaaaaaaaaaaaaa 2.bbbbbbbbbbbbbbbbbb 3.cccccccccccccccccc
Desired Output : 1.aaaaaaaaaaaaaaaaa
2.bbbbbbbbbbbbbbbbb
3.ccccccccccccccccc
How to achieve desired output in text box?
Regards,
Varun
Breaks can be inserted using chr(10), for example:
='1.aaaaaaaaaaaaaaaaaa' & chr(10) & '2.bbbbbbbbbbbbbbbbbb' & chr(10) & '3.cccccccccccccccccc'
In this case it is essential to use "=" at the beginning.
Regards,
Michael
Michael,This will help only when we are inputing text from our end but here we are exporting text directly to text box from external source.The question is can we modify the already exported text or not?
It should be possible. You have to replace "line feeds" in the original text with the chr(10) or chr(13) on reload.
(I'm pretty much sure I've done it, but it's been awhile).
If you upload an example of your data (text file?), I can give it a try tomorrow. Or somebody else will while I'm away...
Some follow-up:
I found my old app, and can tell that there was no need to anything special in my case. Loaded email bodies from SQL database, all formatting preserved.
Need and example of your app with the data source.