Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphical display in continuous forms (XP)

    I have a continuous form which will display just 2 pieces of data: a name and a percentage. The percentage is calculated, so won't be updateable by the user. I was hoping to display it in a creative way; my first attempt was to use a ProgressBar control (but they don't have a ControlSource so I can't link it to my data) and my second attempt was to use a horizontal bar chart (but Access tells me it doesn't like displaying graphs on continuous forms).

    If needs be I can just use a boring text box but if anyone has any other bright ideas or cunning ways around the above problems, then I'd love to hear from you...
    Waggers
    If at first you do succeed, you've probably missed something.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graphical display in continuous forms (XP)

    You could use a borderless and transparent text box with a control source like this:

    =String([Percentage],124)

    Character 124 is the vertical bar |, you can experiment with other characters and fonts (but restrict yourself to fonts that are available on every PC)

  3. #3
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphical display in continuous forms (XP)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Now that's a great idea. I expect | will do fine - I can adjust the total length if I need to by multiplying [percentage] by my desired number of bars. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans.
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •