carriage returns in Access

Question

User-911157248 posted

The problem I am having is when a user types in a paragraph in a multiline textbox and I insert it into an access memo field, it all gets saved in one solid paragraph with missing line feeds / carriage returns. How to solve this?

 

Answer 1

User-1199946673 posted

How do you conclude this? Because when you show the content of the memo field in HTML, a line feed / carriage return will not be displayed in HTML, you must replace them with <br> tags

Answer 2

User-911157248 posted

I have the memo field set to rich text to experiment. I display the memo using aa detailsview. But anyhow what are my options?

 

Answer 3

User-1199946673 posted

In the ItemTemplate, use

<asp:Label ID="Label1" runat="server" Text='<%# Eval("memofield").ToString().Replace(Environment.NewLine, "<br />") %>' />

 

Answer 4

User-911157248 posted

Does this address the multi line textbox I have? Are you using a label instead?

 

 

Answer 5

User-1199946673 posted

Does this address the multi line textbox I have? Are you using a label instead?

 

 

Yes, you can use this in teh ItemPTemplate of the detailsview... It would help if you showed the html markup of your detailsview?

Answer 6

User-911157248 posted

I have figured it out, does this make sense? I moved the replace line to the top of my code rather then where it was (3rd line from the bottom.)

 

tb3 = tb3.Replace(Environment.NewLine, "<BR>")

 

   AccessDataSource1.InsertParameters.Clear()

   AccessDataSource1.InsertParameters.Add("tb3", TypeCode.String)

    AccessDataSource1.InsertParameters("tb3").DefaultValue = tb3

 

AccessDataSource1.InsertCommand = "insert into blah values (@tb3)"

 AccessDataSource1.Insert()       

Answer 7

User-1199946673 posted

This is one of many ways. If it works for you then it is OK....