Solved wildcards with a parameter (Mach Case) (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is disabled for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I have a macro event ApplyFilter, I this to write code to Mach Case at Where condition
I have this code and it is working good [Expr1] Like "*" & [Forms]![SearchF]![Txtbox] & "*", but I want it to Mach the case exactly
My tries but they did not work
[Expr1] Like [Forms]![SearchF]![Txtbox]
[Expr1] Like [Forms]![SearchF]![Txtbox] & "*"
[Expr1] Like "*" & [Forms]![SearchF]![Txtbox]
[Expr1] Like "*" [Forms]![SearchF]![Txtbox] "*"
[Expr1] Like "[" [Forms]![SearchF]![Txtbox] "]"

plz help!

 

[arnelgp]

can you use Instr() function:
the last parameter of the function (0 = vbBinaryCompare).

Instr(1, [Expr1], [Forms]![SearchF]![Txtbox], 0) <> 0

 

[Sarah.M]

can you use Instr() function:
the last parameter of the function (0 = vbBinaryCompare).

Instr(1, [Expr1], [Forms]![SearchF]![Txtbox], 0) <> 0

Thank you for your reply,
No, I want to Match exact number
For example I put 77 I got 3 records, I should get only 1 record
Sample attached

 

[arnelgp]

you can use = sign:

[Expr1] = [Forms]![SearchF]![Txtbox]

 

[Sarah.M]

you can use = sign:

[Expr1] = [Forms]![SearchF]![Txtbox]

I Tried = sign, but got no records
plz help

 

[arnelgp]

try with your field name:

[A]=Forms!SearchF!txtMach

 

[Sarah.M]

try with your field name:

[A]=Forms!SearchF!txtMach

Yes! it works!
Thanks indeed