I doubt this would change anything, but maybe there's some particular quirk with your machine or install or something, so maybe this might work:

I am a loud man with a very large hat. This means I am in charge

Thanks for the advice Steven. I tried my code on another machinewith MS-Access 2000 and got the same problem. It's odd, if I display the variable content with a Msgbox I get the right thing "MTLACCOUNTING", however in the debug the content of the variable is "MTLACCOUNTING".

I also tried the code you provided but with not much success.



[LGuzman]