[AccessD] Percentage Gauge

[Rocky Smolin]

On a datasheet I don't think you can make one cell wider than the rest in
its column like you can with Excel.

If you make the field (column) on the datasheet that will hold the bar say
2" wide, then you've got 2880 twips to play with.  I did this once by
putting a zero width label or text box (can't remember which) on the report
with the background set to black. Then during execution, I set the width of
that control to reflect the magnitude of the data it was representing. And
walla! a bar. In your case .02 (1/100th of the width) * percentage * 100
should give you a bar the with of the percentage.  This will work even with
a width of 1". Even 1/2" where each percent would be .005".

r

On Sat, Dec 17, 2022 at 10:02 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Rocky,
>
> Yes, it is a user requirement.  They want to show a pretty graphic along
> with the boring number 😊
>
> It doesn't need to be accurate - just an indication.
>
> Yes it can be turned on it's side (in fact that would be best since there
> is not lots of vertical space).
>
> The figure is just a measure of how much is used of the total amount
> available (which is pretty much what a percentage is 😊)
>
> Your suggestion is what I thought of first but I am not sure how it can be
> implemented on a datasheet.
>
> Regards
>
> David
>
>
>
> -----Original Message-----
> From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com>
> On Behalf Of Rocky Smolin
> Sent: Sunday, 18 December 2022 6:28 pm
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Percentage Gauge
>
> Bar would be much easier. There are 1440 twips per inch. So you could do
> 14 twips per percentage point. But the information shown that way would be
> of little value. One inch is not enough to discriminate variations on the
> data. How much space have you got for this bar?  Could it be turned on it's
> side like a progress bar?
>
> Curious to know why this rendering is required. I assume some user gave
> you a spec?
>
> What is it measuring that is, percentage of what?
>
> r
>
> On Sat, Dec 17, 2022 at 8:32 PM David Emerson <newsgrps at dalyn.co.nz>
> wrote:
>
> > Hi Listers,
> >
> >
> >
> > I have a percentage field that I would like to represent either as a
> > circle or a bar showing the amount as a percent of 100.
> >
> >
> >
> > This is on a continuous form in datasheet mode.  The size of the
> > graphic will obviously not be very high.
> >
> >
> >
> > Does anyone have any suggestions?
> >
> >
> >
> > Regards
> >
> >
> >
> > David Emerson
> >
> > Dalyn Software Ltd
> >
> > Wellington, New Zealand
> >
> >
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>