[AccessD] Decimals Problem

[Charlotte Foust]

How can quantity on hand be a fraction?  If it's the result of a
calculation of some sort, using the Currency data type will eliminate the
extra decimals.


Charlotte Foust
(916) 206-4336

On Wed, Sep 16, 2015 at 7:53 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Dear List:
>
> In an app there's a text box bound to a quantity on hand field.  Sometimes
> there is no exact equivalent in hex of a decimal fraction value.  So
> instead
> of showing 150 the box shows 149.998475.  There is a user-specified
> preference in a table specifying the number of decimal places to display.
>
> Problem 1: If I set this in the property sheet instead of through code in
> the _Open event, it works.  Setting the .DecimalPlaces property in code
> does
> not work in the case of 149.998475.
>
> Problem 2: Even if I can get the number to display as 150 by setting the
> .DecimalPlaces property to zero, when I click into the text box the number
> changes from 150 to display 149.998475.
>
> Problem 3, the user I think will want one or two decimal places to show
> wherever quantity on hand shows in the app - but not sure.  Maybe they'll
> buy off on zero places.
>
> Any leads on how to solve this greatly appreciated.
>
> MTIA
>
> Rocky
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>