change a line in a memo field??

  • Thread starter Thread starter normanf
  • Start date Start date
N

normanf

Hi there,

How can I change alter a line or a section in a Memo field
on a form (using Vba), without destroying the format /
layout of the current text??

many thanks in advance

noman
 
In Access 2000 or later, you can use the Replace() function, e.g.:
MyMemo = Replace([MyMemo], "What to replace here", "replacement text
here"")

As an example, open the Immediate window (Ctrl+G), and enter this:
? Replace("Your child, {childname}, has been found.", "{childname}", "Nemo")
 
Back
Top