Hi.

I want to set up a rule that says: 255.255.0.0 includes all IP addresses from X.X.0.0 to X.X.255.255 is allowed. Using the inputmask guide I managed to do something like this but it doesn't stop an user typing integers outside the allowed range.
How do I do that in Access? All I found on the web was about phone no. and I can't quit figure out how to adapted that.

 - mega

__________________
- mega
Aspiring JavaScript Ninja

You seem to have mixed that up. Don't you mean 0.0.255.255, not 255.255.0.0? Or did you mean you want IP addresses from 0.0.X.X to 255.255.X.X? Your first value as the 255s in the front but your rule has the 255s at the end. Which is it?

The input mask is not what determines the rules by which the field abides. That falls upon the property Validation Rule.

Assuming what I said about 0.0.255.255, set up your field to be type DOUBLE. Set the input mask as you already set it. Then for Validation Rule, enter:

>= 0 And <= 255255


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

If you want any valid IP address it might be easier to convert from dotted quad to a double and then test if it's in the range 0 to 4294967295.


Code here from Rick:
http://www.freevbcode.com/ShowCode.asp?ID=938



--

Joe