Char(n) SQL data type equivalent in Microsoft Access?

If you know for sure that your values will be limited to 0 thru 100, I'd suggest using a single character in the database and employ the Byte data type in computations. A check constraint could guarantee that you don't fall out of range when adding/changing values and zero-padding can be handled at the appropriate time programatically rather than trying to store them physically.