title: How to specify a custom format for a text pattern in Microsoft Access?
body: <p>I have a <strong>text</strong> column that is 1 or 2 characters long that contains only a number from 0 to 99.</p>
  
  <p>What (text) format do I use to display it with a 0 prefix when it's only a one digit character?
  This means '8' is displayed as '08' while 23 is left unchanged '23'.</p>
  
  <p>I know how to do this when the field is <strong>numeric</strong> instead of text. All I need to do is putting 00 in the format field for this numeric column. Now I want to do the same when the field is text. Thanks.</p>