Find and replace inside of a memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a memo field where i would like to put a special code. Wnen the report prints, i would like to substitute the code with a calculated value. does anyone have a code snipplet that i can use to do the find and replace function (in a memo field)

Thanks in advance

George
 
You can try
=Replace([MemoField],"Code","Description")
or
=Replace([MemoField],"Code",[DescriptionField])

--
Duane Hookom
MS Access MVP


George said:
I have a memo field where i would like to put a special code. Wnen the
Click to expand...
report prints, i would like to substitute the code with a calculated value.
does anyone have a code snipplet that i can use to do the find and replace
function (in a memo field)
 
Back
Top