Printable View
Hi guys,
I am allowing users to fill a textbox with information, including carriage returns. Then I store this information into a memo field in an Access database.
However, when I pull the information back out of the database, all the carriage returns have become "||"
Does anyone have an idea on how to preserve the carriage returns or at least format the information properly for display?
Thank you in advance.
You need to make the text box "multiline" property true.
If you want MORE formatting (i.e. font, size, bold, italics etc. etc.) to be preserved, then use the rich text box.
I'm sorry I never have had that problem also doing that in a lot of cases. When you display the memo again is it again in a textbox which is set to multiline = true ? I'm using MS Access 2000 and DAO since Windoes 95 up to XP now. In all that cases it works, so maybe this occurs in an other enviroment. If so, you can read out which characters that are in debugmode and then restoring them to vbCrLfusing Instr(...) and mid(...) function.Quote:
Originally Posted by twistedfrog
Jonny Poet
I had the multiline set to false - once again you guys are lifesavers! Thanks a bunch!
You are welcome :wave:Quote:
Originally Posted by twistedfrog
cool. no prob