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

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??
 
G

Guest

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.
 
J

Jeff Boyce

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top