Input Text Box Filter

[grantc]

Hi All

I am trying to apply an "IP Address" input filter to a text field in Access '97 has anyone done this ?

I want the entries to be saved as 127.0.0.0 etc

Any Ideas ?

 

[kathryn]

Do you mean an input mask? I never remember the exact rules for IP addresses, but if you remind me I can help you design one. What are the possible lengths of each part?

You will need to store the periods, so you will have to use the \ operator.

If the first group must be three digits, and the next three sections can be two or three characters, then the input mask would be:

000\.900\.900\.900

0 is the place holder for a required digit, and 9 is the placeholder for an optional digit.

Check out the Input Mask Property in the Help file.

Hope this helps. Kathryn

 

[LonnieJohnson]

I tried this as an input mask and it seemed to work for IP config:

000.0.0.0.0;0

Hope this helps. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[grantc]

Thanks Guys !

I have tried both methods and they work great.

 

[dougal1269]

If anyone else needs this solution ... this is the one I use for an IP Address input mask.

!!###.###.###.###;0;_

it works well ... {P