Identifying carriage return in VBA

>Hi
>I'm trying to export some data from an Access table to Sage Line 50
>using VBA. It works fine, except that very occasionally one of the
>fields contains a carriage return. If I step through my code in debug,
>it handles the carriage return by replacing it with a square in the
>middle of the text.
>
>I need a way in Access of identifying the carriage return and
>replacing it with a space. Is there a function I could use to do this?
>
>I'm using Access 2003.
>
>Thanks
>
>Colin

On Tue, 10 Jul 2007 13:28:13 -0000, Bobby <bob...@blueyonder.co.uk>
wrote:
>
Consider using the Replace function for that.
-Tom.
>
>
>>>>>>
- Show quoted text -