Field concatenation

[Trojnfn]

I have a field named dimensions in my table and it should contain something like 10x10x10 ft., for example.

In my form, I don't want to display the dimensions field and have users type in 10x10x10 ft. I want to break it up into four different fields. For example, it will display something like this :

__L x __W x __ H __(pulldown for ft. or inches).



So the user will know to enter the lenght, then witdh, then height, then pick whether it is ft. or in. But when I write to the table, I want to concatenate everything and store it as 10x10x10 ft.

How can this be done ?

[pdebaets]

First, of all, you should store the data as 4 separate fields in your table. This will make it easier to bring the data up on a form for editing, as you won't have to convert it back and forth.

To concatenate the fields, simply create a query based on your table and add a new field to the query which concatenates the fields together. If your table is named "BuildingSpecs", then I suggest you name your query "qryBuildingSpecs".

Add a field to the query that looks something like this:

Dimensions: MyLengthField & "x" & MyWidthField & "x" & MyHeightField & " " & MyUnitsField

Now you can use the query as the record source for a form or report, and you can include the Dimensions field as a read-only control.