Solved

MS Access 2010 - Chart Visibility

Posted on 2016-09-15
5
41 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
[X]
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
5 Comments
 
LVL 52

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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

696 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