Removing Non Printable Characters

[Fredriksson via AccessMonster.com]

Does Access have a function like the Excel function Clean that will strip out
the Non Printable Characters in a column? I have a file that is too large to
use Excel

 

[John W. Vinson]

Does Access have a function like the Excel function Clean that will strip out
the Non Printable Characters in a column? I have a file that is too large to
use Excel

Not directly, but you can run an Update query using the Replace() function to
replace *specific* ASCII codes. For example, you could remove all occurances
of the NUL character (hex 00) with a query updating fieldname to

Replace([fieldname], Chr(0), "")

John W. Vinson [MVP]