Number format 1

[jgarnick]

Is there a way to format a number field to display it as 001, 002, 003 etc.?<br><br>Thanks!! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[PaulF]

yes, use Format([FieldName],

 

[PaulF]

What I meant to say, and I thought I did was, use<br><br>Format([FieldName,&quot;000&quot<br>&nbsp;<br>you can place this in the beforeupdate, or afterupdate events<br><br>PaulF<br>

 

[jgarnick]

Thanks!&nbsp;&nbsp;It worked, I actually placed it in my code where I set up my variable.&nbsp;&nbsp;I learn something new everyday! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>