Multiple Lines

  • Thread starter Thread starter S.F.
  • Start date Start date
S

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
 
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.
 
Back
Top