Jim-
If the data in the memo field is formatted rich text, then it might work to create a text box control that has a Control Source of:
=[MemoField] & " " & [DateField]
.. and make sure the control is formatted for Rich Text.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 4, 2014, at 1:01 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar