Senin, 04 Agustus 2014

[MS_AccessPros] Add form reference in a memo field

 

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: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Yahoo Groups
New - View Group Photos by Time or Location
Enjoy your group's photos beautifully arranged by date or place


.

__,_._,___

Tidak ada komentar:

Posting Komentar