In Access 2007 how do I replace a character (say "~") with a new line. I have tried using the Replace box with ALT+010 but it is not accepted as new line.
The alternative to a VBA solution, is a fairly simple SQL query.
Without being able to test it on your database I can't guarantee safety, so please backup before trying, and you'll need to replace the table and field names as required.
You should, in fact, be able to create and run this using the query builder if you wish, just make sure you're working on an update query and enter the
Here's a quick VBA function which should do what you want. Drop it in to a new code module within the database, tweak it as necessary, and then give it run.
Obviously, I can't guarantee this is entirely safe without testing it on your database, so make a really good backup before trying this out! And, I've not made any effort to generalise the function, just tailor it to the requirements given.
Note that I'm using this on a test database that just has