number to text

[endri81]

How to enter in textbox number for example 1 and to turn in textbox text for example cat?


Regards

[June7]

Why do you need to do this? With more info on your situation and we might be able to help.

[endri81]

I have a list of cities with their specific zip code which is only digits.I want to search the city by specific number example when I enter number ten returns LA
Regards

[June7]

There is more than one way to accomplish this.

Include the zip/city table in the form's recordsource then can display the city in a locked textbox. Be sure to get the jointype correct.

I suggest the zip control be a multi-column combobox then can display both zip and city in the drop list.

You would enter only '10' - that would be a record ID, not the zip code or the last 2 digits of zip?

Anything else will involve code.