Thread
:
easy control data value question
View Single Post
#
3
May 7th, 2010, 01:12 AM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
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
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]