vbCRLF does not display on iPhone

JamesF 2017-07-01 20:00:16 UTC #1

I am storing and retrieving data containing carriage returns from an SQLite database on the device. Works just fine on Android and BlackBerry but the carriage returns have no effect on the iPhone. The text all runs together with no line breaks.
I tried this:
dim sNote, backslash
backslash = Chr(92)
sNote = record["Note"]
sNote=Replace(sNote,vbCRLF,backslash & "n")
I also tried:
sNote=Replace(sNote,vbCRLF,"\n")

StackOverflow says to put a "\n" in place of the carriage return\Line Feed but what I am doing does not work.
Any help would be greatly appreciated.

Thanks
JamesF

Eric_Pankoke 2017-07-01 22:09:12 UTC #2

Since the ultimate output is HTML, try using < br > (no spaces).

JamesF 2017-07-01 22:37:45 UTC #3

Thanks Eric.

But, no, I am not using HTML. It is straight ASCII text being inserted into a Boostrap textarea.

JamesF

Eric_Pankoke 2017-07-02 00:08:54 UTC #4

I know you're not "using" HTML per se, but in the end that's all a web app is. I could be completely off base, but did you actually try using the < br > tag in place of the vbcrlf (which, incidentally, is basically a \r\n anyway)?

JamesF 2017-07-02 00:26:56 UTC #5

I gave it a try, just in case. You never know! J

It just does what I expected though. I end up with a
strings inserted into the text.

I save customer-typed text to a database and I then retrieve it and display it for editing in a textarea. It is not saved as rich text/HTML nor is it edited as rich text/HTML. Straight, unformatted ASCII text.

Thanks for your input.

Eric_Pankoke 2017-07-02 00:54:22 UTC #6

Unfortunately I don't have any way to test anything at the moment and I don't want to give you any more potential ideas that I can't vet out myself. Good luck, and if you figure it out before someone here provides the answer, please post what you found out.

JamesF 2017-07-02 00:56:20 UTC #7

Thanks Eric.

Will do.

JamesF