How do format a field in Access to accept a leading zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to format a field in Access to accept a leading zero in a two digit
number?

This is posing a big problem for me. I know it's an easy fix. Please help
me??
 
I acctually figured it out, I needed to format the field as text and not a
number and I was able to format the field and have a leading zero without
using a decimal in front of it, as this was not a numerical equation.

I hope this helps someone else. It was an easy fix once I started reading
the formats of the other fields around it.
 
Glad you were able to figure out a solution.

Unless you will be "doing math" with the "numbers", they aren't really
numbers. Another example would be US East Coast zip codes (they start with
"0") -- they look like numbers, but I've never heard of someone multiplying
them...<g>!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
if you ever need to manipulate such pseudo numbers in a mthematical equations
use the built-in function CInt("text variable"), CDbl("text variable") and
CLng("text variable) to convert to Integer, Double or Long respectivly.
 
Back
Top