Number Format dropping preceding zero on 1 User's form

W

Williams

I have a field in my table named [project] which should contain a 5 digit
number. Some of these numbers begin with a zero, so to prevent the preceding
zero from disappearing I formated the field as "00000". This works great on
the table and in the combo box for this field on the form. However, one of my
users just got a new computer and the combo box on the form is dropping off
the preceding zero on just her workstation. This field displays the
preceding zeros on other workstations. Any ideas??
 
F

fredg

I have a field in my table named [project] which should contain a 5 digit
number. Some of these numbers begin with a zero, so to prevent the preceding
zero from disappearing I formated the field as "00000". This works great on
the table and in the combo box for this field on the form. However, one of my
users just got a new computer and the combo box on the form is dropping off
the preceding zero on just her workstation. This field displays the
preceding zeros on other workstations. Any ideas??

My idea is that you should not be using a Number datatype for this
field. Are you ever going to perform math using this field? Probably
not.
Make it a Text datatype. Preceding zeroes are retained, so no need to
format the field value.
 

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