<div>
Bear in mind that the Format function yields a String -- it has to be a String to have a leading zero. &nbsp;So you may have to change the field data type to Text.
</div>


Bear in mind that the Format function yields a String -- it has to be a String to have a leading zero.  So you may have to change the field data type to Text.

<div>
If the column is a date field, set the format to MM. If it's a number field, set format to 00.<br />
<br />
Flyster
</div>


If the column is a date field, set the format to MM. If it's a number field, set format to 00.

Flyster

<div>
<div class="content wysiwyg-content">
i have a column of months that i need to format to two digit numbers.<br />
<br />
example:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;convert &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07<br />
&nbsp; &nbsp; &nbsp; &nbsp;convert &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; remains same<br />
<br />
thanks!
</div>
</div>


i have a column of months that i need to format to two digit numbers.

example:

       convert          7            to               07
       convert        10            to               10   remains same

thanks!

format number in access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.