View Full Version : Adding Together Cells Data


peters
11-20-2000, 06:12 AM
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
11-20-2000, 06:32 AM
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
11-20-2000, 06:36 AM
Thanks. I will give it a try.