Multiple Lines

[S.F.]

This is the exact value I have in a field in an access
table. How do I get it all on 1 line instead of 6?


Import nine Tables
all Received data including their demo info

demo info (name type = example)
cal
history

 

[Ken Snell]

Run an update query that deletes all combinations of Chr(13) & Chr(10)
(ACCESS uses this combination of characters to make a new line). Use the
replace function in a calculated field:
NewValue: Replace([OldValue], Chr(13) & Chr(10), "")

This may leave extra blank spaces if your text string contained them at end
or beginning of lines.