• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 816
  • Last Modified:

How can I replace " " in all records with a new line in a memo field in Access 2007?

I impored an HTML table & it has   where I'd like a new line.  How do I make that happen?  It's easy in Word, but there are no find/replace features Access for formatting. Guess I have to do an upate querry.
0
leslieinva
Asked:
leslieinva
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Make a backup up first, then try this:

UPDATE Table1 SET Table1.FIELD1 = Replace([FIELD1]," ",Chr(13) & Chr(10));


mx
0
 
Kelvin SparksCommented:
Try using the Replace function on the data

Replace("&nbsl","newvalue")

Kelvin
0
 
hieloCommented:
backup your db and try:
update tablename set fieldname=Replace(fieldname,' ',Chr(10) )
0
 
leslieinvaAuthor Commented:
That worked!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I believe the Accepted answer is exactly what I posted first ....

mx
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now