Search and replace within a text box

[DJ_DEF_CON_1]

I have a text box that is populated by a table after a combo box selection has been chosen. I would then like it to replace a certain word (Place Holder) with one word that is a result of another query.

i.e. My friend (FRIEND) likes widgets.

The sentance comes from a table which is then populated into a text box. I would like it to replace "(FRIEND)" in the text box with a name that is a result of another query.

I am not planning on saving any of this data into a table. A report is based off this form and then printed.

Thanks for any assistance that you may have.

 

[dcx693]

You can get the result of a query through code by opening it up as a recordset and taking the value out of the field you want.

Use the Replace function to change the words in the text box.