Formatting SQL/Access Fields

[AndyApp]

Can anyone tell me if it's possible to pull data from SQL/Access and keep the formatting? For example I have an Access front end that allows people to insert addresses into one of the fields on multiple lines such as:

address 1
address 1,1
address 1,1,1

but when I get the data it just all comes out on one line:

address 1 address 1,1 address 1,1,1

I need it as it is in the database. "Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[FesterSXS]

when you read the data from the database use the following:

strAddress = Replace(objRecordset(&quot;Address&quot;),vbcrlf,&quot;<BR>&quot;)

This will replace the linebreaks in the database with valid HTML linebreaks Tony

http://www.phoenix-paints.co.uk/portfolio

 

[GabeC]

You could also wrap your text in the <pre></pre> tag.

Thanks,

Gabe