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)

 

[Steve101]

If the string field contains carriage return, line feed characters, then the string will be broken up on output into the separate lines. These characters are represented by chr(13) and chr(10) respectively. I usupect that the line folding that you may be currently observing may be because the control witch setting on the data entry form forces the lines to fold on display, rather than having the explicit carriage retun, line feed characters in the data.

Note, to add these characters to a string field in a form, press control and enter simultaniously.

Hope this helps, Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au