Memo Prevent Alt Enter   

Is there a way to standardize the memo field once updated to remove all "alt 
enter" spaces?  Kind of in the same way it would standardize case problems 
like:
me.memo = strConv(me.memo), vbproperCase)

Thanks in advance.

date: Tue, 26 Aug 2008 14:33:12 -0700   author:   meyerryang

Re: Memo Prevent Alt Enter   

meyerryang wrote:

>Is there a way to standardize the memo field once updated to remove all "alt 
>enter" spaces?  Kind of in the same way it would standardize case problems 
>like:
>me.memo = strConv(me.memo), vbproperCase)


Mot sure what that means, but maybe you get the desired
effect by using the Replace function?

-- 
Marsh
MVP [MS Access]

date: Tue, 26 Aug 2008 17:33:59 -0500   author:   Marshall Barton

Re: Memo Prevent Alt Enter   

If I replace it, how do I eliminate the hard return (space).  Thanks in 
advance.  

For Example:
Accountname 1012 (the space right here which starts a new line below!!!)
New York, NY


"Marshall Barton" wrote:

> meyerryang wrote:
> 
> >Is there a way to standardize the memo field once updated to remove all "alt 
> >enter" spaces?  Kind of in the same way it would standardize case problems 
> >like:
> >me.memo = strConv(me.memo), vbproperCase)
> 
> 
> Mot sure what that means, but maybe you get the desired
> effect by using the Replace function?
> 
> -- 
> Marsh
> MVP [MS Access]
>

date: Wed, 27 Aug 2008 07:12:00 -0700   author:   meyerryang

Re: Memo Prevent Alt Enter   

On Wed, 27 Aug 2008 07:12:00 -0700, meyerryang
 wrote:

>If I replace it, how do I eliminate the hard return (space).  Thanks in 
>advance.  
>
>For Example:
>Accountname 1012 (the space right here which starts a new line below!!!)
>New York, NY

Back up your database first, just in case.

You can run an Update query updating the memo field to

Replace([memofield], Chr(13) & Chr(10), " ")

to replace all hard returns with a single space.

The hard return is encoded as a carriage return character followed by a
linefeed character, ASCII values 13 and 10 respectively.
-- 

             John W. Vinson [MVP]

date: Wed, 27 Aug 2008 09:51:51 -0600   author:   John W. Vinson

Re: Memo Prevent Alt Enter   

That worked great - it didn't take making another query, though.

me.memo = Replace(me.memo, Chr(13) & Chr(10), " ")

Thanks again.

"John W. Vinson" wrote:

> On Wed, 27 Aug 2008 07:12:00 -0700, meyerryang
>  wrote:
> 
> >If I replace it, how do I eliminate the hard return (space).  Thanks in 
> >advance.  
> >
> >For Example:
> >Accountname 1012 (the space right here which starts a new line below!!!)
> >New York, NY
> 
> Back up your database first, just in case.
> 
> You can run an Update query updating the memo field to
> 
> Replace([memofield], Chr(13) & Chr(10), " ")
> 
> to replace all hard returns with a single space.
> 
> The hard return is encoded as a carriage return character followed by a
> linefeed character, ASCII values 13 and 10 respectively.
> -- 
> 
>              John W. Vinson [MVP]
>

date: Wed, 27 Aug 2008 14:58:03 -0700   author:   meyerryang