I've been asked to do something insane

  • Thread starter Thread starter RobertM
  • Start date Start date
R

RobertM

Hello:

The database that I am working on has a field where data
is entered into a subform.

Our lot #'s (the value that is entered into this field)
are #'s such as 234, 235, and 236.

We are manually entering data from an ancient legacy
system into this Access database. The old system shows the
#s as 000234, 000235, and 000236.

I need to set this database up so that when data is
enteded into this field the three zero's appear in front
of it. To make matters worse there are no wizards
installed on my MS Access.

Thank you

Robert
 
Hello:

The database that I am working on has a field where data
is entered into a subform.

Our lot #'s (the value that is entered into this field)
are #'s such as 234, 235, and 236.

We are manually entering data from an ancient legacy
system into this Access database. The old system shows the
#s as 000234, 000235, and 000236.

I need to set this database up so that when data is
enteded into this field the three zero's appear in front
of it. To make matters worse there are no wizards
installed on my MS Access.
Click to expand...

The wizards aren't smart enough to help with this in any case... <g>

Simply define the field as being of Text type instead of Number. As a
number the values 000235 and 235 are EXACTLY THE SAME NUMBER, just
displayed in two different ways. If you want to be able to store
000235 and 235 as separate, distinct lots you must use a text field.

If you want to store the number 235 and display it with leading zeros,
whether or not the data came from the old database, use a Long Integer
field and set its Format property to 000000.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
RobertM said:
Hello:

The database that I am working on has a field where data
is entered into a subform.

Our lot #'s (the value that is entered into this field)
are #'s such as 234, 235, and 236.

We are manually entering data from an ancient legacy
system into this Access database. The old system shows the
#s as 000234, 000235, and 000236.

I need to set this database up so that when data is
enteded into this field the three zero's appear in front
of it. To make matters worse there are no wizards
installed on my MS Access.
Click to expand...

On all of your forms and reports that display this number just set the
format property to "000000".
 
Back
Top