Search results

Well now I know what's causing it!! Useful advice, thanks. Barrie

Hello I tried this but got the error message "Undefined function FindandReplace in expression". I'm using Access 97. Thanks for your help so far. Regards Barrie

Wow, quick response! Now, I looked at the Replace String Function but to be honest I don't know what to do with it:(. Where do I place it and how do I get it to find ascii 13 and replace it with nothing? Sorry if I'm being thick! Cheers Barrie

I can only see the square/oblong character in the spreadsheet after the csv export. I can delete this but by then the damage has been done and following records are out of sequence because the rogue carriage return has created a new record at the wrong place. I have seen this error before (not...

I use Access 97 to collate visit reports. I then export these as a csv file. Occassionally a rogue carriage return (ascii 13) appears in a text box. This has the effect of knocking the csv out of sync. I have no idea what is causing this (the carriage return looks like a small box in the...