View Single Post
  #4  
Old May 7th, 2010, 05:14 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default easy control data value question

Even though I don't care for creating the expressions in the query, I expect
Steve forgot to change the "=" to ":"
PNameCITitle: [ProjectName] & chr(13) & chr(10) & [CurrentIssueTitle]

--
Duane Hookom
MS Access MVP


"Steve" wrote in message
...
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