Converting of a few words to the other

[zozzz]

hi everyone

I have tow Textboxes on the form. Inside one sentence and the other is empty

How can I turn up Specified word to another ?

Something like the following code :

Case "Apple" = Orange

Case "Fish" = Cat


Thank you so much

[June7]

What are the rules for replacing one for the other?

I don't see a sentence, just single word.

Perhaps a table of the equivalents.

[davegri]

How many "Cases" do you have? If only a few which don't change, you can hard code it.
If it's a lot, you can have a table that has "Apple" in one column and "Orange" in another.
Assuming that Apple is typed into the first textbox, do a DLookup to find the substitute word to put in the second textbox via the after_update event for the first textbox.

[zozzz]

hi . please check this

[zozzz]

How many "Cases" do you have? If only a few which don't change, you can hard code it.
If it's a lot, you can have a table that has "Apple" in one column and "Orange" in another.
Assuming that Apple is typed into the first textbox, do a DLookup to find the substitute word to put in the second textbox via the after_update event for the first textbox.

about 30 cases

[June7]

I think will need VBA along with a table of equivalents or else hard-coded in the VBA procedure.

[davegri]

Hard code example-
The on_Click event for the convert button:

text2 = Text1
Text2 = Replace(Text2,"Fish","Cat")
Text2 = Replace(Text2,"Apple","Orange")
...and so on

[zozzz]

Hard code example-
The on_Click event for the convert button:

text2 = Text1
Text2 = Replace(Text2,"Fish","Cat")
Text2 = Replace(Text2,"Apple","Orange")
...and so on

Unfortunately, it was not work . I think this method is for conversion only one

if the character conversion module is available, it also suffices

[orange]

@zozzz,
Where does the data in the text box come from? Is it in a table?

If English is not you native language, you can use google translate to
a) write a description of what you are trying to in business terms (plain talk no database terms/jargon)
b) translate result to English and post it.

We need more info about your database and context to offer more focused responses.

Good luck.

[zozzz]

@zozzz,
Where does the data in the text box come from? Is it in a table?
...
Good luck.

No - unbound text box

[davegri]

zozz-v1.zip
This replicates your form Text1 and Text2 and does the conversion exactly if you enter the same example data into text1. Code is same as in post #7

If this doesn't meet your needs, explain further.

[zozzz]

Thanks davegri


how can I use this in "public function Module" ?

[davegri]

how can I use this in "public function Module" ?

zozz-v2.zip
Like this. Includes new UDF (user defined function) in a new code module.

[zozzz]

thankyou

[davegri]

Glad to make you happy! Good luck with the rest of your project.