[AccessD] Percentage Gauge

[David Emerson]

Thanks Rocky and Stuart,

Between the two of you I think I have a solution.

Much appreciated

David


-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On
Behalf Of Stuart McLachlan
Sent: Sunday, 18 December 2022 7:06 pm
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Percentage Gauge

You could make it clearer with something like

PCSTring = String$(pc / 5, ChrW(&H2588)) & String$(20 - pc / 5,
ChrW(&H2591))

On 18 Dec 2022 at 15:58, Stuart McLachlan wrote:

> I doubt that you will find a graphic solution in DataSheet mode, since 
> that is essential a text grid display.
> 
> Probably the best bet would be a string of some suitable character 
> such as
> 
> Function PCSTring(pc As Long) As String
>     '0-100 will produce a string of blocks 0 to 20 charcters long
>     PCSTring = String$(pc / 5, ChrW(&H2588))  'Unicode Full Block End 
> Function
> 
> 
> On 18 Dec 2022 at 17:32, David Emerson 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