Setting Field Size for Number Type

[Pamela Gordon]

Hi, I'm new to Access, I'm running Access 2002. For a Field Name called
"Year" I have Data Type to be "Number". Now I want to make the Field Size to
be only a 4 digit integer, could some one tell me what should I do to set it
like this? Thanks a lot in advance......Pam

 

[Allen Browne]

Open the table in design view.
Select your Year field.
In the lower pane, enter a Validation Rule of:
Is Null OR Between 1000 And 9999

 

[Pamela Gordon]

Thanks a lot.....

Open the table in design view.
Select your Year field.
In the lower pane, enter a Validation Rule of:
Is Null OR Between 1000 And 9999

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Size set