Search in listbox

[#1]

Hello,

I have a listbox with dates. The date format is DD-MM-YYYY.  Normally if I select a month, I enter in the search box of the listbox the MM-YYYY. Then I can select the month. The problem I have is that this normally works, but I have one file, that it isn't possible to do this. Can someone help me with this, please?

With kind regards,

Aissam

[datanibbler]

Hi Aissam,

well, since you haven't attached or included any specific information, I can only make an assumption:

=> Maybe that table isn't properly linked.

Is there a date_field in that table? Try with that one (make sure it doesn't have the key_icon - fields with the key_icon behave a bit differently and can't be used for that kind of testing).

HTH

Best regards,

DataNibbler

[Anonymous]

Compare "default search mode" in the file that works and the file that doesn't work.  It is in the list box properties, tab General

[#4]

Script is: 

MakeDate

(Mid(LABOR_TIME_COMPLT_LEFT,1,4),Mid(LABOR_TIME_COMPLT_LEFT,5,2),Mid(LABOR_TIME_COMPLT_LEFT,7,2)) as DayDateFinished,

[#5]

checked, looks the same.

regards,

aissam

[#6]

it doesn't use * * automatically? When I entered it works.

[Anonymous]

It is wildcard search mode...