Memo Prevent Alt Enter

  • Thread starter Thread starter meyerryang
  • Start date Start date
M

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.
 
meyerryang said:
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)
Click to expand...


Mot sure what that means, but maybe you get the desired
effect by using the Replace function?
 
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
 
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
Click to expand...

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.
 
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 said:
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
Click to expand...

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.
Click to expand...
 
Back
Top