Reports

[Anit]

Would I be able to display data from 2 or more fields into one text box in
reports?
I have got multiple fields, however wish to combine the data in all of these
fields and display in one text box in my report?

 

[Allen Browne]

Set the Control Source of a text box to an expression like this:
=[FirstName] & " " & [Surname]

Make sure the text box's Name property is not the same as one of the fields
(e.g. it can't be called FirstName or Surname in the example above.)

In some cases, you will find that it doesn't work unless you put (hidden)
text boxes for these fields on the report as well.

 

[Allen Browne]

Set the Control Source of a text box to an expression like this:
=[FirstName] & " " & [Surname]

Make sure the text box's Name property is not the same as one of the fields
(e.g. it can't be called FirstName or Surname in the example above.)

In some cases, you will find that it doesn't work unless you put (hidden)
text boxes for these fields on the report as well.