combine display of IP address segments

[Guest]

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

 

[Guest]

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

-Michael

 

[Guest]

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

 

[Guest]

You should not be saving this calculated data into a new field. Doing so is
a violation of basic normalization. If you want to see the entire IP address
in one field in Excel, include the calculated field in a Query, and export
that Query to Excel.

-Michael

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