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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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*"
 
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, many thanks. I think I got something wrong when the database converted
to 2003 version.

Steve Schapel said:
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*"
Click to expand...
Click to expand...
 
Back
Top