Help with Validation rules in 2007

[Scott Ashton]

Hi all,

I am currently creating a networking database and i have a field for "subnet
mask" within a table and have correctly setup the input mask -
999\.999\.999\.999;;_
so that data is entered in the correct format as follows:

<1st octet>.<2nd octet>.<3rd octet>.<4th octet>

When data is then entered it would read something like:

255.255.255.000 or 255.248.000.000 etc, etc

My question is, what validation rule do i need to ensure that ONLY numbers
from 0 to 255 can be entered into each section? I have tried everything and
i got as far as 3 "octets" but then the last allowed me to enter a number
greater than 255.

Also could you help me design it so that i can only enter "0" and not "000"
if this is possible, or make access remove the two leading zeros when "000"
is entered? The same applies to any 1 or 2 digit number, ie 1 instead of
001, or 12 instead or 012.

Many thanks

Scott Ashton
MCP MCDST

 

[Allen Browne]

Scott, a very simple solution is to use 4 Number fields of size Byte, rather
than one Text field with the numbers and dots.

That's actually what an IP address is: 4 bytes. You can design your form so
the labels have a dot between the text boxes.