View Single Post
  #3  
Old May 7th, 2010, 01:12 AM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default easy control data value question

If the report' recordsource is not already a query, make the recordsource a
query with all the fields you need in the report. In a blank field in the
query put:
PNameCITitle = [ProjectName] & chr(13) & chr(10) & [CurrentIssueTitle]

Then in the controlsource of the textbox put PNameCITitle.

Steve




"Mark Kubicki" wrote in message
...
I have a report which has on it a text box
when I enter the data value for the control as ProjectName it works fine
when I enter the data value for the control as CurrentIssueTitle it works
fine
(both are in the report's data source)

however, when I enter:
= [ProjectName] & chr(13) & chr(10) & [CurrentIssueTitle] the result is
an #error#
even if I simply enter:
= [ProjectName] & [CurrentIssueTitle] the result is an #error# it's
still an error


any suggestions would be greatly appreciated in advance,
Mark
...learning something new every day