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!
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!
Last edited: