Adding Together Cells Data

[peters]

Is it possible to create on a form several cells for entry and than another cell that takes what is in those cells and puts it all together.

For example:
Cell 1: PBV
Cell 2: 2000
Cell 3: Report


Cell 4: PBV2000Report.

 

[simongallop]

This example is using three text boxes for the input (txt1, txt2, txt3)

The output is in txt4

Goto the properties of txt4. Under the Data tab there is a field called Control Source
type in the following code:
=[txt1] & [txt2] & [txt3]
HTH
Simon

 

[peters]

Thanks. I will give it a try.