appending text in memo field

  • Thread starter Thread starter mail
  • Start date Start date
M

mail

I need to build a description in a bound Memo Field by choosing
existing text phrases from a list. I've tried using a List Box, but
any item I choose simply replaces the one already in the Memo Field.
I want each item I choose to append itself to existing items in the
Memo Field.

I'm sure I'm missing something obvious, but it seems to elude me.

Any help is appreciated.
 
Hi,
like this:
--> Me.txtTheMemo = Me.txtTheMemo & " " & strNewPhrase

Me.txtTheMemo is the description already in the memo field.
strNewPhrase is the text phrase from the list.
You add a new phrase from the list by using &, then addd a space " ", then
use & to add the new phrase.
Do this each time a new phrase is added.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Hi,
like this:
--> Me.txtTheMemo = Me.txtTheMemo & " " & strNewPhrase

Me.txtTheMemo is the description already in the memo field.
strNewPhrase is the text phrase from the list.
You add a new phrase from the list by using &, then add a space " ", then
use & to add the new phrase.
Do this each time a new phrase is added.

Jeanette Cunningham -- Melbourne Victoria Australia
Click to expand...

Jeanette,

Thank you so much for your response.

I think that my description was not adequate. From the form, the user
will pick words or phrases from a previously prepared list which will
then populate a bound Memo Field. As each word or phrase is chosen,
it appends itself to the previous phrase in the Memo Field, thereby
building a description which will be saved as part of the record. The
list will contain, for example, words and phrases such as:

TV Ring Power Tool Guitar Computer

LCD Plasma Gold Diamond Table Saw Miter Saw Drill
Electric Acoustic Laptop Desktop

Sony Toshiba Dell Fender Gibson HP Washburn Stratocaster
Telecaster

19inch 27inch 32inch 36inch

Multiple items are chosen from the list using mouse clicks to build a
description in the Memo Field such as: "Sony LCD TV 32inch" or
"Fender Stratocaster Electric Guitar." When the user is satisfied
with the description in the Memo Field, they simply move on the the
next field in the form.

The list is not bound and simply contains items which can be plucked
for insertion in the Memo Filed. The list can be edited to add or
remove items as needed with no effect on already existing records.

Please forgive my clumsy effort to describe the problem. Once again,
any help is appreciated.
 
Hi,
the code I posted in my previous reply would go on the After Update event of
the list box.
If the memo field is empty and the user clicks the word <ring> in the list
box, the listbox runs its after update code and we get
the word <ring> in the memo field.
Next the user clicks <gold>, the after update code of the listbox runs again
and we get
-->ring gold
in the memo field


Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top