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