combine display of IP address segments

[Harry]

In my form, I have a section to enter in a customer's IP address. I have four
text boxes and each one is setup to accept byte-sized numbers. I want to
combine the display of these numbers into one column with the "dots" placed
appropriately. For example, making this:

IP IP2 IP3 IP4
192 68 3 239

look like this:

IP address
192.68.3.239

 

[Michael H]

Add an unbound TextBox to your form. Set the Control Source to something
like this:
=[IP] & "." & [IP2] & "." & [IP3] & "." & [IP4]

-Michael

 

[Harry]

Thanks for your help. There is just one more thing that I neglected to
mention. I want to save this display of these four IP columns into another
column to be used later in a simple report in Excel. Would this require a
different approach?

Add an unbound TextBox to your form. Set the Control Source to something
like this:
=[IP] & "." & [IP2] & "." & [IP3] & "." & [IP4]

-Michael

In my form, I have a section to enter in a customer's IP address. I have four
text boxes and each one is setup to accept byte-sized numbers. I want to
combine the display of these numbers into one column with the "dots" placed
appropriately. For example, making this:

IP IP2 IP3 IP4
192 68 3 239

look like this:

IP address
192.68.3.239