What is wrong with this? [Nome] Like "*[Forms]![Form1]![box1]*" ggstenz 03.03.2006 16:07:27 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*"

Re: What is wrong with this? [Nome] Like "*[Forms]![Form1]![box1]*" Steve Schapel <schapel[ at ]mvps.org.ns> 03.03.2006 18:28:01 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 ggstenz wrote: [Quoted Text] > 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*" > >

Re: What is wrong with this? [Nome] Like "*[Forms]![Form1]![box1]* ggstenz 03.03.2006 19:07:30 Steve, many thanks. I think I got something wrong when the database converted to 2003 version. "Steve Schapel" wrote: [Quoted Text] > 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 > > > ggstenz wrote: > > 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*" > > > > >