Can anyone tell me if there is a way to set a text field in Access with preceedings zeros, outside of using an input mask? I have a field that must be 16 characters in
length, with anywhere from 10-12 of the preceeding characters being zeros. It
must be a text datatype rather than a number, and an input mask apparently only
allows up to 12 characters in lenth. If there isn't a way to set preceeding
zeros, then I'd like to right tab the field to allow the user to only have to
enter the value not being zeros, and then we can have Oracle SQL script populate
the preceeding zeros for us when we send the data to the permanent tables on the
server.
Thank you.
