Setting Field Size for Number Type

  • Thread starter Thread starter Pamela Gordon
  • Start date Start date
P

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
 
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
 
Thanks a lot.....

Allen Browne said:
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
Click to expand...
 
Back
Top