Combining Control Sources for Use in Reports

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



Answer this question

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])


  • Combining Control Sources for Use in Reports