easy control data value question

[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

 

[John Spencer]

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

 

[Steve]

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)

 

[Duane Hookom]

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

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)

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]

Thanks for the correction, Duane.

Steve

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

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)

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