>>It should still work fine assuming you didn't have integer values more than 6 digits (and you most likely didn't). I still don't see a problem.
>
>Thank you for clarifying. I thought that even if you have value of 1 in the integer field and use STR(MyField,6) the result will be "******".
To be sure, I've tried it right now in the command window. It worked fine - no ***
If it's not broken, fix it until it is.
My Blog