If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
easy control data value question
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 |
#2
|
|||
|
|||
easy control data value question
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 Mark Kubicki wrote: 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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|