Access - removal of all Carriage line returns (ascii 13)

Associate
Joined
7 Dec 2005
Posts
16
Hey all,

just a wee quick one, despite a number of mixed results trying to get rid of these in expression builder, i've come to the conclusion a tiny vb module may be better at removing these pesky things.

i have to extract them into a pipe delimited file, which is not a problem but i need from the last character removing from the field (every record in this field has the (ascii 13) line break.

does any1 have a clear cut idea or a simple way of going about this, or one that can search every field? ideas welcome.

ta.
 
Back
Top Bottom