How to maintain Text Format?

  • Thread starter Thread starter Miguel Dias Moura
  • Start date Start date
M

Miguel Dias Moura

Hello,

I created a page with one form and 10 Input Text fields.
The Form data is added to an Access Database when "OK" button is
pressed.

One of the Form's Input Text has more than one line.
The user uses this to write its Curriculum Vitae.
The Curriculum Vitae is inserted in the MEMO type "CV" field.

However, all the data is placed in the same line.

Example - The visitor inserts this:
I am a webdesigner.
O started working in year 2000.
I work in ASP and Flash.

And I get this in the database:
"I am a webdesigner.O started working in year 2000.I work in ASP and
Flash."

What should I do to maintain the format of the inserted text?

Thank You,
Miguel

P.S: I am using DW MX 2004 (I use Insert Record Behavior), ASP.Net / VB.
 
Hi,

if you use ASP.NET's TextBox (and it has Wrap property set to true by
default) it should save also line breaks along with the text. If they are
displayed in database (Enterprise manager etc) is up to the tool but they
should be stored pretty much without anything special.

If you put the text to display on page (not TextBox but Label for example)
from database, you'd of course need to replace line breaks with <br> tags so
that they are visible (HTML browser ignores linebreaks when they are within
HTML).

You can try adding wrap="hard" to the control's Attributes collection (e.g
txtBox1.Attributes("wrap")="hard" , you can't with declarative syntax
because Wrap property already exists) so that carriage returns and line
feeds are submitted for sure. As I said, they should be sent if Wrap
property (the boolean property) isn't set to False for TextBox, though it
seems with decompiling that wrap property wouldn't be set to be soft or hard
(soft is default), so to be sure you can add the wrap manually.
 
Back
Top