Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sjgoodin

    Format a field with leading zeros

    Thanks, Skip. While I agree with you it doesn't help. The required (government) specs of the data my table will hold requires leading zeros on numbers that are less than 7 digits. I am only trying to make it convenient for the user not to have to enter a number like "123" as "0000123".
  2. sjgoodin

    Format a field with leading zeros

    Need help on formatting a numeric field. Field length is 7 characters. I want to allow users to enter less than 7 digits and if less than 7 digits, automatically add leading zeros and have it stored that way.

Part and Inventory Search

Back
Top