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 Michael.But still not able to do line break.
Current Output: 1.aaaaaaaaaaaaaaaaaa 2.bbbbbbbbbbbbbbbbbb 3.cccccccccccccccccc
Desired Output : 1.aaaaaaaaaaaaaaaaa
How to achieve desired output in text box?
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.
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...
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.