Combine Text Fields in Report

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hello,
I am trying to combine text fields on a report and get an
error message. The fields are [Duration] and
[Misc_Info]. I want them to print on a report with
Duration first, then Misc_Info. Access 97 help shows =
[Duration] & " " & [Misc_Info]. This isn't working. I've
tried substituting the & with And, this didn't work
either. Any suggestions?
 
Mary,

=[Duration] & " " & [Misc_Info] should work fine. Just make sure that
the ControlName for this text box is not the same as a Field in the report's
RecordSource.
 
That was it.
Thanks!
Mary
-----Original Message-----
Mary,

=[Duration] & " " & [Misc_Info] should work fine. Just make sure that
the ControlName for this text box is not the same as a Field in the report's
RecordSource.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Hello,
I am trying to combine text fields on a report and get an
error message. The fields are [Duration] and
[Misc_Info]. I want them to print on a report with
Duration first, then Misc_Info. Access 97 help shows =
[Duration] & " " & [Misc_Info]. This isn't working. I've
tried substituting the & with And, this didn't work
either. Any suggestions?
Click to expand...


.
Click to expand...
 
Hi there,

I have Access 97 and use this feature on several of my
reports. Ensure that there are spaces everywhere that
i've indicated on your email below with an underscore.

Hope this helps.
 
Back
Top