Search results

hi, I use list box as criteria to find records from ado.find and has clicks many row. Can someone show me the code to view more than one record using ado.find or ado.filter. I wonder if the ado.find can accept more than one criteria to search the records.

What i mean is the number of characters display in the column. I use memo type in the table field but still not more then 255 characters display in a list box column..

The column in my list-box did not show all the text i save in the table field. is there any limited size for list-box's column to show the data ?

This code working good : lResult = Replace(Me.Text1, "hotel", "motel", , , vbBinaryCompare) lResult = Replace(lResult, "Hotel", "Motel", , , vbBinaryCompare) lResult = Replace(lResult, "HOTEL", "MOTEL", , , vbBinaryCompare) Me.Text1 = lResult Thanks Ari for your help.

Thanks You.

Actually there are more than one "hotel" words in my textbox. What I need is to make every word replace with same case. Example : "hotel" to "motel" "Hotel" to "Motel" "HOTEL" to "MOTEL" I try the "replace(me.text1,"hotel","motel",,,vbBinaryCompare )" but not working. I don't know how to use...

I post my mdb sample:rolleyes:

Sorry. I don't get it. How would I use this function with the Replace function. Thanks.

The Replace Function did not return the result with the case sensitive. Example if I set the Replace Function like : Replace(me.text1,"hotel","motel") the result will be = "motel" even if the word inside the me.text1 is "Hotel". please help me.

hallo, i' am Deen and from Malaysia. Actually i dont study in programming fields but i find out that this applications is good:) and i would like to learn more about it.