Input Mask for IP address

[Ryan Langton]

I'm trying to create an input mask for IP addresses and it is not
cooperating with me. I want to be able to input IP addresses the same way
windows allows. Example: Keyboard Input 1 9 2 dot 1 6 8 dot 0 dot 1 results
in 192.168.0.1.

Using an input mask 999.999.999.999 (or #'s) results in 192.168.01 (notice
no dot between the 0 and 1).
Using an input mask with 0's throws errors unless all 12 digits are entered
(IE 1 9 2 dot 1 6 8 dot 0 0 0 dot 0 0 1).

Any way to do this?

Thanks,
Ryan

 

[aaron.kempf]

gosh i would just do this via VBA

but it seems like.. you should be able to try this first

009.009.009.009

i think that SHOULD do the trick good luck

-aaron