By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,830 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,830 IT Pros & Developers. It's quick & easy.

Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08

P: n/a
Title says it all. Using a Listbox to look up numbers - ie SSN for a
student - and then all of a sudden it shows up as 2323E+08 instead of
say 232-23-2323. Help!

Also, how can I force zeroes to appear in a key number? This is
necessary for use with IDs beginning with a zero.

Finally, input forced to begin in far left of field? There is a
character used, and for the life of me I cannot recall.

Writing in a rush, so sorry if this is a mess. Thanks for help.
Please remember I am a novice, and be specific.

Thanks, too, to others who have helped me in the past!

Sami
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Access controls will display numbers in scientific format when the control
is not wide enough to display the number otherwise. Just widen the control.

You can not store leading zeros in a numeric field. You can display them,
using the Format property of the control, but if you need to actually store
them in the table you need to use a text field.

--
Brendan Reynolds
<Sami> wrote in message news:fq********************************@4ax.com...
Title says it all. Using a Listbox to look up numbers - ie SSN for a
student - and then all of a sudden it shows up as 2323E+08 instead of
say 232-23-2323. Help!

Also, how can I force zeroes to appear in a key number? This is
necessary for use with IDs beginning with a zero.

Finally, input forced to begin in far left of field? There is a
character used, and for the life of me I cannot recall.

Writing in a rush, so sorry if this is a mess. Thanks for help.
Please remember I am a novice, and be specific.

Thanks, too, to others who have helped me in the past!

Sami

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.