Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS Access 2010 - Chart Visibility

Posted on 2016-09-15
5
29 Views
Last Modified: 2016-10-30
Is there a way to make a chart non-visible if there is no data in the chart? I pose the same question for a subform, if there is no data in the detail section of a subform can the whole subform be made non-visible?
0
Comment
Question by:Elemental Drake
5 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 250 total points
ID: 41801015
is that Chart linked to a data source?

is that possible we check that same query, if that query returns 0 record, we hide the Chart accordingly?

we may need to do this in Form_Load or Form_Current event.
0
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 250 total points
ID: 41801722
You can make a section visible or invisible depending on some evaluation -- here is an example:

Private Sub Form_Current()

   If Val(Me![OrderID]) > 100 Then
      Me.Section(acFooter).Visible = False
   Else
      Me.Section(acFooter).Visible = True
   End If
   
End Sub

Open in new window

0
 

Author Comment

by:Elemental Drake
ID: 41801747
This would probably work as a last resort. I would like to have the textbox that labels the sections to appear. This way it will still relay the message that this person was accounted for but there is no data associated with them.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 41801756
Could you position the textbox at the bottom of the Detail section, so it would appear even if the section is invisible?
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 41865715
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Ryan Chong (https:#a41801015)
-- Helen_Feddema (https:#a41801722)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question