67 minutes
ago: Doing some maintenance on the server today. If you've placed an order and it hasn't processed yet, hang in there. Should be ready soon. I've got the car up on the jack and the tires are off...
Dismiss
I want my bank account number field to equal "00000000" as when I have a 7 digit code with a leading 0 access only holds the 7 digits and omits the first 0
Bank uploads only accept 8 digits with a leading 0
eg 9145439 becomes 09145439
In excel i used to type '09145439 access returns an error
or cuts out the leading 0 as 9145439
I have done this before but cant for the life of me think what I did.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Forum.
