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)

 

[mithrilhall]

Can you use the split function and split this on the comma? ====================================
I love people. They taste just like
chicken!

 

[MerlinB]

Use the VBScript or JavaScript 'replace' function to convert newlines to <br> tags.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)