If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create an Input Mask for an IP Address
I have some IP Addresses I need to capture in my database table. I need to
be able to create 4 sets of 1 to 3 digits in a set and when displayed there are no spaces. I want to be able to input 10.1.28.147 or 155.108.153.210 and have each come out just as you see them here. I haven't been able to get the right configuration where if I only have 1 or 2 digits per set the spaces are removed and you only see 10.1.28.22. If you use 1 or 2 digits in a set I want the spaces removed and everything shifts in to leave no blanks or spaces. |
#2
|
|||
|
|||
How do I create an Input Mask for an IP Address
I would design and input it as four different numeric fields
then concatenate it together for display purposes. [field1] & "." & [field2] & "." & [field3] & "." & [field4] -- _________ Sean Bailey "Baksg1995" wrote: I have some IP Addresses I need to capture in my database table. I need to be able to create 4 sets of 1 to 3 digits in a set and when displayed there are no spaces. I want to be able to input 10.1.28.147 or 155.108.153.210 and have each come out just as you see them here. I haven't been able to get the right configuration where if I only have 1 or 2 digits per set the spaces are removed and you only see 10.1.28.22. If you use 1 or 2 digits in a set I want the spaces removed and everything shifts in to leave no blanks or spaces. |
#3
|
|||
|
|||
How do I create an Input Mask for an IP Address
On Jun 17, 4:07*pm, Baksg1995
wrote: I have some IP Addresses I need to capture in my database table. *I need to be able to create 4 sets of 1 to 3 digits in a set and when displayed there are no spaces. I want to be able to input 10.1.28.147 or 155.108.153.210 and have each come out just as you see them here. *I haven't been able to get the right configuration where if I only have 1 or 2 digits per set the spaces are removed and you only see 10.1.28.22. *If you use 1 or 2 digits in a set I want the spaces removed and everything shifts in to leave no blanks or spaces. Just my opinion, but I would store them as 4 separate values of size byte. Then you can only enter values between 0 and 255. |
#4
|
|||
|
|||
How do I create an Input Mask for an IP Address
On Jun 17, 5:03*pm, Beetle wrote:
I would design and input it as four different numeric fields then concatenate it together for display purposes. [field1] & "." & [field2] & "." & [field3] & "." & [field4] -- _________ Sean Bailey "Baksg1995" wrote: I have some IP Addresses I need to capture in my database table. *I need to be able to create 4 sets of 1 to 3 digits in a set and when displayed there are no spaces. I want to be able to input 10.1.28.147 or 155.108.153.210 and have each come out just as you see them here. *I haven't been able to get the right configuration where if I only have 1 or 2 digits per set the spaces are removed and you only see 10.1.28.22. *If you use 1 or 2 digits in a set I want the spaces removed and everything shifts in to leave no blanks or spaces. Me too... I have no idea how to limit the individual octets to a byte size any other way... |
Thread Tools | |
Display Modes | |
|
|