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

G

ggstenz

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*"
 
S

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.
 
G

ggstenz

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...
 
Top