Advertisement

02.14.2008 at 06:13AM PST, ID: 23162934
[x]
Attachment Details

Access 2007 - Report Detail On Format Event

Asked by alliedtech in Access Coding/Macros, Microsoft Access Database, Access Reports

Tags: Microsoft, Access, 2007

I have a report that feeds directly from a query.  In the detail section of the report, I have a label ("ProdNotes") and a text box ("Comments").  The goal is to allow the user to click on "Notes" and then view the comments associated with that record in a pop up form.  However, if the "Comments" text box is null, then I do not want the "Notes" label to appear on the report for that record.  The below code is in the On Format event of the report's detail section.  The code executes perfectly in Access 2003, but the On Format event is not triggered in Access 2007.  The On Click event works fine in both versions.  Is this an unavoidable bug in Access 2007, or is their an alternative solution.  Thanks in advance for any assistance.Start Free Trial
 
Keywords: Access 2007 - Report Detail On F…
Title
1 Group Policy and Login issues after tra…
2 Goal Seek in Access
3 Trigger event when data changes
4 create trigger
5 UpdatePanel and triggers
6 Access 2k Label Printing
 
Loading Advertisement...
 
[+][-]02.14.2008 at 08:14AM PST, ID: 20894574

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.14.2008 at 09:32AM PST, ID: 20895302

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.14.2008 at 11:35AM PST, ID: 20896405

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.14.2008 at 11:56AM PST, ID: 20896578

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 03:42AM PST, ID: 20900877

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Microsoft Access Database, Access Reports
Tags: Microsoft, Access, 2007
Sign Up Now!
Solution Provided By: boag2000
Participating Experts: 2
Solution Grade: A
 
 
[+][-]02.15.2008 at 03:52AM PST, ID: 20900910

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 05:06AM PST, ID: 20901267

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 05:35AM PST, ID: 20901443

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 07:57AM PST, ID: 20902876

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 08:05AM PST, ID: 20902970

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.15.2008 at 09:16AM PST, ID: 20903772

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.15.2008 at 09:56AM PST, ID: 20904151

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.18.2008 at 07:17AM PST, ID: 20920520

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.18.2008 at 07:35AM PST, ID: 20920702

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.18.2008 at 11:32AM PST, ID: 20922683

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628