Hi All,
My situation: I have two fields in a table: FirstName and LastName. I want to put them in a report, but not be seperated in to two seperate text boxes (e.g. the fields may look like this: [John ][Smith ], with padding because the text box is a pre-defined length), but rather one box (e.g. [John Smith ]. Does anyone have a suggestion as to how I could get it two together in one field for view in Print Preview in a report
Thanks in advance,
Mat

Combining Control Sources for Use in Reports
StephenMas
Hi
Add a text box to your report ( which will be unbound) then in control source type in, or use the builder,
=Trim$([FirstName]) & " " & Trim$([LastName])