If you work with IP addresses, you probably already know that it is not as straightforward as working with text or numbers. This is because an IP address is really a collection of four numeric values separated by a period (.), where each value is a number between 0 and 255.
The reason IP addresses are challenging to work with is that Access does not provide a special data type for storing IP addresses. And even though the address is just a collection of numbers, you cannot store the addresses in a numeric field. This is because a numeric field supports only a single decimal point (.), whereas an IP address contains three periods (.). This leaves you with only the option of storing the addresses in a text field. Read more »