Results 1 to 3 of 3
  1. #1
    helloworld's Avatar
    helloworld is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    10

    Access 2007 - Changing Chart Font Size Not Working


    Hi everyone,

    Been having an on-and-off issue with font sizes when making a chart in Access. My chart is currently embedded within a report.

    My problem is this:

    After creating my chart, Access is saying that the font size is set to 8, but it is blatantly not. It is much larger. The font will not properly change, no matter what font size I change my chart area, value axis, or category axis to.

    I have tried turning off Auto-Scale under the font options but it does not change the font-size.

    What is interesting is that on several charts the issue has randomly fixed itself and show the font as 22 when I edit the chart object. Perhaps I edited something by accident that fixes the issue?

    Any help would be greatly appreciated.

    helloworld

  2. #2
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453

    font size

    Hi

    I'm an Access novice so this may be totally off track but I have been caught out a few times with similar issues.

    I'd make sure that nothing else is controlling the font size in the hierarchy of your forms

    ie the form, then any containers and then your chart etc etc. If in doubt place you chart on a clean new form and try it there.

    I had a "similar" issue when calling a form via a macro, when I opened the form direct it was perfect and when I called it via a macro it was wrong because the macro controlled the view and tool precedence over the form settings

    Also check the font you are using I always use the MS defaults fonts.

    Apologies if I've taken you astray

    cheers

    Ian

  3. #3
    helloworld's Avatar
    helloworld is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    10
    Hi Ian,

    Any suggestions are appreciated! Thank you.

    After some digging I seem to have found a fix. If you right click the chart object and select Size -> To Fit then the the chart editor shows the correct font and properly displays it.

    helloworld

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

Similar Threads

  1. Replies: 3
    Last Post: 07-28-2014, 03:02 PM
  2. Changing Font in Access Report Header
    By ZLHysong in forum Access
    Replies: 1
    Last Post: 02-01-2013, 03:17 PM
  3. Changing Font Color and Size in table
    By FormerJarHead in forum Access
    Replies: 2
    Last Post: 01-09-2013, 01:04 PM
  4. Replies: 0
    Last Post: 03-10-2012, 11:35 PM

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 - Senior Forums