Change Elemnt Type or Valuelist on the fly?

Hi Folks.

On my form I have some fields defined as combobox’s using a valuelist. Works fine. :)

However, when I use ‘find’ the user can only select from the drop down list, but I’d like him to be able to enter multiple search criteria in that field!

Is there a way to change the element display type from Combobox to text_field on the fly (I could make that change in my find function)? I cant find a way to do that in the available methods? :?

Alternatively could I just remove the Valuelist ? Again, cant see how I might do that on the fly? :?

A third alternative would be to have a second element on the form relating to the same field, set to text_area, and normally hidden - which I could un-hide on ‘Find’ function. But that’s really messy and feels like a work - around.

In some other environments (I’m thinking specifically Access) one can use a combobox which allows the user to select from the list - but also to edit the field - the field entry is not limited to the list (unless set as such overtly).

How do others handle this situation?

you could look if you could make the combobox editable in find?

jcompagner:
you could look if you could make the combobox editable in find?

I think you can only do that if the valuelist shows a single value. If there are two values (one in the Db and a different one in the display) then I cant edit the content.

Or did I miss a point?

yes and i am looking if there could be some things for find.

Because what would you be able to type into that box in find? a concat of multiply of those values in the list?
Then we have to search for the right values and make a IN find for that field?

if that is something you want please make a case for that.

jcompagner:
yes and i am looking if there could be some things for find.

Because what would you be able to type into that box in find? a concat of multiply of those values in the list?
Then we have to search for the right values and make a IN find for that field?

if that is something you want please make a case for that.

Done thanks Johan