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!

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

Leading zero 1

Status
Not open for further replies.

Chumley40

Programmer
Jan 24, 2005
71
US
How do I format a field so if the number is 1 it will show 01.

I tried format(field, "#0"), format(field, "00") but neither work.

Anyone know?
Thanks
 
Format(field, "00") should work just fine. What result do you get?? What is the root datatype of the "number" 1??

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer
 
that was the problem. I changed it to an integer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top