Annoying problem with currency decimal places ?

[Don Garry]

Hello, I have a form which has several calculated controls on it which are
tied to currency figures. For example I've got a control called SellingPrice
in which the format is set to currency and the decimals is set to auto. All
numbers show correctly as currency (eg. $356.71) until I put the focus on
the control at which time the control shows a swack of digits ?? (e.g.
$356.713244465656). The moment you put the focus on another control the
selling price goes back to the correct format.

I would have thought that the round function would have solved this but it
doesn't have any effect in how I'm using it.

I would sure appreciate it if someone could shed some light on this little
annoying problem I'm having.

 

[Mark]

Try setting the decimal places property for the field to 2 instead of auto
in the table's design.

 

[Don Garry]

Hi Mark, I tried that and the problem still persists.

Any other suggestions ?

 

[Marsela]

Try in calcualated controls to use before the fields
formatcurrency([fieldname],2) and force decimal places to
2, for the other controls that depends on data entry (not
calculated controls) try in save or close button to force
the format also, which updates in tables like
=formatcurrency([fieldname],2) and so on.

Thanks,
Marsela