[AccessD] Find and Remove Carriage Return

instr([FieldName],chr(13)) works perfectly.

Then I can just replace that character or simply cut off anything after the
carriage return.  In this case, I'm cutting everything off,

Thanks, everyone.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Friday, June 02, 2006 4:37 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Find and Remove Carriage Return
>
>
> Instr and look for chr(13)?
>
> Rocky
>
>
> Reuben Cummings wrote:
> > How can I look into a field and find and remove any returns?
> >
> > Thanks.
> >
> > Reuben Cummings
> > GFC, LLC
> > 812.523.1017
> >
> >
> >
> >
> >
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>