>Good Day all!
>
>My question is this...I have a field in my table called OrderId it is 7 characters long. If an id is entered that is three characters (ex. 123) I would like to have it replaced with leading zeros to the max of C(7) (ex. 0000123). Is this possible to do in the table designer..input mask or format fields? Any other suggestions?
>
>Thanks for your time!
You can do it in the valid of atextbox
This.Value = PADL(This.Value, 7, "0")
I'm curious why do you allow to enter key field instead of generating it internaly?
--sb--