easy control data value question

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

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
 
What is the NAME of the textbox CONTROL? Is it possibly the same name as one
of the fields? If so, change the control's name.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
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
(e-mail address removed)
 
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 said:
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
(e-mail address removed)



Mark Kubicki said:
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
Click to expand...
Click to expand...
 
Thanks for the correction, Duane.

Steve


Duane Hookom said:
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 said:
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
(e-mail address removed)



Mark Kubicki said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top