* Filter does not work in numbers field (1 Viewer)

[kevnaff]

Hi All.

Just in the past week on my database I have found that I cannot use the * filter in a numbers field. I get an invalid syntax message when trying to do so.

I have used the * filter in a numbers field for years and have not changed anything in the database. I have changed the field to a short text field and the filter works completely fine so there is no issue going forward.

Does anybody know if this was part of an Access update?

Thanks

 

[bob fitz]

Can you show us the code that produces the error?

 

[ebs17]

part of an Access update?

I like that.

The use of wildcards and thus pattern search is processing of strings and has absolutely nothing to do with numbers. For something like this to work, numbers must be internally converted to strings. This hidden datatype-trallala is actually a violation of clean programming.

Give me all salaries with a 1 in them: What is the meaning of the following result?

FieldX Like "*1*"

1, 10000, 213, 33333331 and so on

 

[Pat Hartman]

I'm surprised that a wildcard search EVER worked with a numeric value. Wildcard searches are for text strings not numbers.