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

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

-Michael



"Harry" wrote:

> 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

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?

"Michael H" wrote:

> Add an unbound TextBox to your form. Set the Control Source to something
> like this:
> =[IP] & "." & [IP2] & "." & [IP3] & "." & [IP4]
>
> -Michael
>
>
>
> "Harry" wrote:
>
> > 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

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


"Harry" wrote:

> 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?
>
> "Michael H" wrote:
>
> > Add an unbound TextBox to your form. Set the Control Source to something
> > like this:
> > =[IP] & "." & [IP2] & "." & [IP3] & "." & [IP4]
> >
> > -Michael
> >
> >
> >
> > "Harry" wrote:
> >
> > > 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