Identifying carriage return in VBA

[Bobby]

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

[Tom van Stiphout]

On Tue, 10 Jul 2007 13:28:13 -0000, Bobby <bo****@blueyonder.co.uk>
wrote:

Consider using the Replace function for that.
-Tom.

>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

[Bobby]

On 10 Jul, 14:40, Tom van Stiphout <[e-mail]:

On Tue, 10 Jul 2007 13:28:13 -0000, Bobby <[e-mail]>
wrote:

Consider using the Replace function for that.
-Tom.

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- Hide quoted text -

- Show quoted text -

Thanks Tom,
Used in conjunction with vbCR and vbLF, Replace has worked fine,

Colin