Form Default Value Question

I understand the concept in creating a default value for new form records when the data type is text, but i can't seem to get the same default value to populate when the data type is number.  

For a text field under the form field's property sheet, i add the default in the default value with quotes around the value.  For instance "00000", but if i do the same thing for a number data type field is only inputs one zero?  What is the process for having multiple zero's populate as a default when the data type is number.  The zero's are proceeding to employee ids so i want them inputted so the complete naming convention is utilized when entering the remaining numbers.  

Thanks.
jsawickiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
<What is the process for having multiple zero's populate as a default when the data type is number.>

if your intention is to have your field zero filled, you need to convert the field to string with

Format([NumberField],"000000")

or use a Data Type TEXT, not Number
jsawickiAuthor Commented:
So that code will go into the default value on the property Sheet under the data tab.  If so, i added it, changed the data type to number and left the field size long integer.  THe results was the field  populating with #Name?
Rey Obrero (Capricorn1)Commented:
here is another way of doing it
open table in design view
select your number field
below, look for the format property and type  00000

now create a form bound to the table..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Jeffrey CoachmanMIS LiasonCommented:
Then I am confused as to why you are asking about "default values", when your question appears to be about "Formatting"

In addition to what capricorn1 posted, you can also:

In the table, set the "Format" Property of this numeric field to: 000000
(Note that there are no quotes around the zeros)
Then any number you enter in the field will have the leading Zeros.
set the format propertyenter a valueformatted with leading zeros
JeffCoachman
Jeffrey CoachmanMIS LiasonCommented:
Ignore my post above, capricorn1 posted the same thing before I did, so he should get the points.

But my point is still valid.
This is "Formatting", it has nothing to do with "default values"

What you seem to be wanting here is a "Default Format", ...not a Default Value...

Jeff
jsawickiAuthor Commented:
Thanks all.  I was just trying to understand the possibility of entering a default value while using data type number and have realized that it works unless the numbers are all zeros then you have to convert to a string.  When it is zeros, it will only list one versus all that are listed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.