I have a field in a form that is 15 digits long. all the entries start 00000000xxxxx. How do I tell access to remove a number of leading zeros in the field?
It is obviously a text field since it has leading zeros. Can you just use the
Right() function?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.