Where, exactly, are you trying to do this? In v2007, using your code behind a Command Button, it performs exactly as you want it to, for me!
Linq ;0)>
Just had a thought (at my age, I try to hold onto to them, they happen so seldom) since the Datatype name has been changed from Text to ShortText, in later versions, does the SQL need to us ShortText, rather than Text? I can't test this in v2007.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007