Find and replace inside of a memo field

[George]

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

 

[Duane Hookom]

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

--
Duane Hookom
MS Access MVP

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)