Memo Prevent Alt Enter

[meyerryang]

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.

 

[Marshall Barton]

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?

 

[meyerryang]

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

 

[John W. Vinson]

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.

 

[meyerryang]

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

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

Thanks again.

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.