trunking data in a form

J

James

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?
 
R

ruralguy via AccessMonster.com

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.

Ask a Question

Top