Select field values with blank spaces in listbox

[#1]

Hi all,

I've a listbox containing phone numbers (text format with blanks to separate the nuber blocks) like shown below:

Unfortunately when searching for a special phone number like '073 001 78 24' all phone numbers containing any of these number blocks are selected. Is there any setting allowing this?

Thanks,

Thomas

[#2]

Hello,

Place the value between double quotes : "073 001 78 24"

it should work

[alexandros17]

use  PurgeChar(phone, ' ')  as expression instead of field phone and use search with special char

[#4 · Accepted solution]

Hi,

Go to list box properties and in general-Search-Default Search Mode select "use wildcard search"

[CELAMBARASAN]

To make it work like that, try with the Wildcard search mode