|
| 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
June 17th, 2009, 10:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
June 17th, 2009, 11:03 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
June 17th, 2009, 11:25 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
June 18th, 2009, 03:53 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
