Finding and Replacing Special Characters in MS Access
Most special characters like Tabs and Line Break and Carriage Returns can be found and replaced in MS Access by using the character codes. But you can't use the find and replace dialog.
Instead, author an update query and enter the following to remove tabs:
If removing line breaks you need to replace both the line break and carriage return character:
If editing for HTML you'd edit this to the following for HTML line breaks:
Replace(Replace([myfield],Chr(10),"<br />"),Chr(13),"<br />")
For other characters, look up the ascii character code. (use the numbers in the "Dec" column in the tables)
What is this?
We use the IFWIS Blog to keep our staff, cooperators and the public updated on what we are working on, what's new and share tips about using our software and website.
The content of the IFWIS Blog is often highly technical, but we try our best to keep our posts accessible and jargon-free. When this is not possible, we'll link to other resources online to provide background. Thanks for reading and please follow our blog for updates.
- IFWIS RSS Feed
- Daily Email Digest (All Public Content)
- Or follow just one of the many topic-specific tag feeds or pages below.