delete a particular row from memo

[Taurus05]

Hi,

I am using a text box to add to memo field of a table. Now I would like to delete a particular row from the memo. SI there a way to do it.

My code fro ading is below (Note. AddtoMemo is a textbox, YourMemo is a memo field).

Thanks

Code (to add text to memo)
=====================

Me![YourMemo] = Me![YourMemo] & " " & Me![AddToMemo]
Me![AddToMemo] = Null

 

[Rabbie]

Just display the memo on your form in a bound box and edit manually on the form. Then it should save the updated version.

 

[missinglinq]

Where the textbox for the text to be deleted is named DeleFromMemo:

Me![YourMemo] = Replace(Me![YourMemo], Me![DeleFromMemo], "")
Me![DeleFromMemo] = Null

Note that this will remove all occurrances of the string from the memobox! If you enter, "Howdy Doody" it will delete this string every time it appears. While this is the default for Replace(), the function does offer ways to limit this replacement to X number of times. See Access Help for details.

Linq

 

[Taurus05]

Thanks for the reply. Will give it a try. It seem like this is the only way to do it.