GrandMasterTuck
In need of medication
- Local time
- Today, 14:39
- Joined
- May 4, 2013
- Messages
- 129
Is it possible to store a TempVar that contains another TempVar within it? For instance:
I want to store a line of greeting in a TempVar, and allow this TempVar to fetch a person's name from another TempVar and embed it in the right place. Like this:
TempVars!Greeting.Value = "Good Afternoon, " & TempVars.TheName & ", how are you today?"
TempVars!TheName = "Jeffrey"
And have the resulting line output like so: "Good Afternoon, Jeffrey, how are you today?"
Note that I do NOT want to STORE the word JEFFREY in the Greeting TempVar, I just want the Greeting TempVar to fetch the data that's stored in the TempVar TheName and place it in the right spot inside that textbox on my form, a textbox who's control source is the TempVar called Greeting.
The purpose of doing this is so that I may create a report that has an introductory paragraph, in which SEVERAL other variables are called (Employee Name, Hire Date, First Day of Work, Scheduled Days Off, etc...) throughout the paragraph. I want to allow the owner to change the wording of the paragraph easily (I provide a form with a field into which he can view and edit the code that generates that paragraph of text, and he can rewrite it as needed) without forcing him to go into design view for the form and edit the code from there.
Is this possible?
I want to store a line of greeting in a TempVar, and allow this TempVar to fetch a person's name from another TempVar and embed it in the right place. Like this:
TempVars!Greeting.Value = "Good Afternoon, " & TempVars.TheName & ", how are you today?"
TempVars!TheName = "Jeffrey"
And have the resulting line output like so: "Good Afternoon, Jeffrey, how are you today?"
Note that I do NOT want to STORE the word JEFFREY in the Greeting TempVar, I just want the Greeting TempVar to fetch the data that's stored in the TempVar TheName and place it in the right spot inside that textbox on my form, a textbox who's control source is the TempVar called Greeting.
The purpose of doing this is so that I may create a report that has an introductory paragraph, in which SEVERAL other variables are called (Employee Name, Hire Date, First Day of Work, Scheduled Days Off, etc...) throughout the paragraph. I want to allow the owner to change the wording of the paragraph easily (I provide a form with a field into which he can view and edit the code that generates that paragraph of text, and he can rewrite it as needed) without forcing him to go into design view for the form and edit the code from there.
Is this possible?