Results 1 to 6 of 6
  1. #1
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45

    How can i change the title of a graph in VBA?

    I am using the Microsoft Graph Object Libary
    I want to change the title of the graph on a report by VBA in the Open event of the report.


    How can I set the title of the graph?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    Thanks for the quick answer.
    But this does not work for my graph
    I do not have that properties

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Can you show us your VBA code and a screen shot with your graph properties details?
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  6. #6
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I found the problem.
    I tried to set the title in the open event of the report.
    I replaced the code to the format event and then it works.
    Thx for the replies.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-12-2016, 11:04 AM
  2. Change generic colour in Title on Form
    By mortonsafari in forum Forms
    Replies: 2
    Last Post: 03-20-2016, 06:11 PM
  3. Change chart title with code
    By Pastor Del in forum Reports
    Replies: 6
    Last Post: 02-11-2014, 08:56 PM
  4. Cannot change column title
    By Ancient Dragon in forum Access
    Replies: 3
    Last Post: 11-12-2012, 08:44 PM
  5. Replies: 2
    Last Post: 05-26-2012, 01:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums