>>I wonder if that's another one of those funny valid things...did you try it in the Lostfocus instead?
>
>Actually I did. Didn't work there either :(
>
Then I might guess it's an SQL string parameter problem. I've noticed that occasionally where a normal string may work in SQL in the command window or high level of code, only a macro (&) will work from some interior places of an application.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.