strange filter result (1 Viewer)

leanpilar

Registered User.
Local time
Today, 10:51
Joined
Aug 13, 2015
Messages
94
It's not a big problem but annoying and not good for reputation with my clients.
A simple list on a form filtered based on a field on the form.
It's work every time but one wrong result it always appear if I digit a correct number.

For make it easier to understand I attach the simple database I made to try to see if only my database is wrong

Try to filter on form any correct number from the field Tablica in the table, the result 286 it will be there :banghead: if you digit a text from the field Ime the filter work correctly.

any other way to filter a list as you digit?

thanks
 

Attachments

  • testfilter.accdb
    388 KB · Views: 50

JHB

Have been here a while
Local time
Today, 10:51
Joined
Jun 17, 2012
Messages
7,732
If you expand (in the high) the record with the number 286, you see the record has all the other number in it! (So no magic here :D)
 

Attachments

  • PU286.jpg
    PU286.jpg
    31.2 KB · Views: 93

leanpilar

Registered User.
Local time
Today, 10:51
Joined
Aug 13, 2015
Messages
94
Wow. Thank you. Probably when I copy all the list and paste here it pasted all there. How did you find it?? Ty ty

Sent from my SM-G930F using Tapatalk
 

Users who are viewing this thread

Top Bottom