By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,377 Members | 472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,377 IT Pros & Developers. It's quick & easy.

How do i convert a value in to a text word?

P: 283
I am having some trouble doing a conversion. What I have is a combo box where if you type in the word All it knows to pull all the records. But because on the query I have running behind the input form the query knows that in order to pull All the records you have to type in "*". So what I did was put in a code on the back end that converts the word All to equal "*", but at the same time in the combo box it will display the symbol "*" is there a way i can get the word "All" To stay in the combo box but still equal the value "*" for the back end??
May 30 '10 #1
Share this Question
Share on Google+
2 Replies

P: 255
I'm a bit misunderstanding on what are you trying to do. As I can see, are you trying to capture a query result into the combo box? If so, just simply put the query into the row source property of the combo box.

If my guess is wrong, can you show us the code of what you have done?
May 31 '10 #2

Expert 100+
P: 1,287
Depending on how your query is set up, you can for example use a (hidden) text box on your form as the input instead of the actual combo box. Either on the after_update event of the combo box, or just before the query is run, grab the combo box value. Copy it to the text box, but if it is 'All', write '*' into the text box.
Jun 1 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.