field sizes

[puthputh]

hello,

i am making a database, and i need to know how to put a field size of FOUR
characters on a NUMBER field and an AUTONUMBER field.

therefore i want all the records to have to have a field size of 4, (no
shorter than 4, no longer than 4)

i am told it is possible, but do not know how.

Thankyou

 

[John Vinson]

hello,

i am making a database, and i need to know how to put a field size of FOUR
characters on a NUMBER field and an AUTONUMBER field.

therefore i want all the records to have to have a field size of 4, (no
shorter than 4, no longer than 4)

i am told it is possible, but do not know how.

A Text field has a field size. A Number field - such as an Autonumber
- does not. The number is NOT stored as four numeric characters; it's
stored as a 32-bit binary integer.

This integer can be *DISPLAYED* showing only four digits by using an
Input Mask and/or Format property consisting of four zeros. This will,
however, not affect how the value is stored in the table; in
particular, an Autonumber may go on to exceed 9999 and then you'll get
an error. If you care about the value of the number - don't use
Autonumber.

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