Jim-
In an earlier reply, you said you saw this output in your query:
<div><font color="#333333">Based on the department and university 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.</font></div>
If that's true, then you should see it properly formatted in a text box set to 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 5:27 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I see the text in the table for the field but not the date field.
Jim Wagner
On Monday, August 4, 2014 2:51 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
If you bind that to a control on a form or report that is formatted as Rich Text, it should display properly. What you're seeing in the query is the raw data that contains the Rich Text formatting instructions.
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 4:35 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
here is my expression in the query. Paragraph2 is the field where the memo text is.
MemoWithDate: [Paragraph2] & [Forms]![frmMainTabbedForm]![txtMaxCompDate]
Jim Wagner
---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :
On Monday, August 4, 2014 12:17 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar