What is wrong with this? [Nome] Like "*[Forms]![Form1]![box1]*"

[Guest]

I have used this sintax in Access 97 but it is just not working on 2003.
Although these variants would work:

[Nome] Like [Forms]![Form1]![box1]
[Nome] Like "*mar*"

 

[Steve Schapel]

Ggstenz,

Try it like this...
[Nome] Like "*" & [Forms]![Form1]![box1] & "*"

As far as I know, the syntax you showed would not work in Access 97 either.

 

[Guest]

Steve, many thanks. I think I got something wrong when the database converted
to 2003 version.

Ggstenz,

Try it like this...
[Nome] Like "*" & [Forms]![Form1]![box1] & "*"

As far as I know, the syntax you showed would not work in Access 97 either.

--
Steve Schapel, Microsoft Access MVP

I have used this sintax in Access 97 but it is just not working on 2003.
Although these variants would work:

[Nome] Like [Forms]![Form1]![box1]
[Nome] Like "*mar*"