Replace value in memo field

  • Thread starter Thread starter HilcrRWise
  • Start date Start date
H

HilcrRWise

I would like to use the Replace function to look within a memo field o
a form and replace a certain text value with a value from anothe
field. I currently have the following replace function linked to
command button, however when it is activated nothing happens, no erro
messages or anything appears but the text value is not changed
although it is obviously there:

ReplaceName = Replace(Me.Comment, "<<NAME>>", Me.FirstName)

Can someone tell me where I am going wrong
 
Are you saying that it isn't working because what's on the form doesn't
change?

You're putting the changed string into the variable ReplaceName. If you want
to change what's on the form, use

Me.Comment = Replace(Me.Comment, "<<NAME>>", Me.FirstName)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restoring line breaks in memo field 1
appending text in memo field 3
Access Access 2003 Carriage Return Insertion 0
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Change the color of each capital letter in a rich text memo field. 0
Update Memo field using VB in a form 1
Date/Time stamp in Memo Field 4
Problem showing memo field in list box 3

Back
Top