Jim
Since the date is on a form, use the form's textbox as a parameter in the report's query.
MemoWithDate: myMemo & [Forms]![frmMainSwitchboard]![txtMaxCompDate]
And be sure to use a bang, not a dot, before the control's name.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :
Hello all,
Is there a way to have a memo field in a text box with rich text formatting have a reference to a form field?
I have a sentence in a table that I need to show on a report. But at the end of the sentence is a date that the user would like to be entered before the report runs.
I use the memo field and rich text formatting to allow the paragraph to be distributed or justified on the page like a memo. It also allows to have the user change the wording on the report instead of the design view of the report. Below is the sentence. the date needs to be whatever the user decides based on the information they need to use. I tried to use..... less by" & " "& [Forms]![frmMainSwitchboard].[txtMaxCompDate]
but that did not work. I saw the string itself.
Based on the department and company maximum compensatory accrual limit of 96 hours, please meet with your employee and agree upon a schedule that will allow them to bring their compensatory accruals to 96 hours or less by October 1, 2014.
Jim Wagner
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar