Thread
:
easy control data value question
View Single Post
#
5
May 8th, 2010, 12:52 AM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
easy control data value question
Thanks for the correction, Duane.
Steve
"Duane Hookom" wrote in message
...
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
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]