Amount Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example I have a form that has a maintenance code and then an amount to
go with that at the bottom I have a tax box and an invoice amount. All of my
amounts are working correctly except for my tax box. For example I want it to
show $24.20 and it will only show $24.00. I can't find any difference in the
propoerties compared to my other ones that are not rounding. Any suggestions
would be a big help.

Thanks,
Kelli
 
A copule of things to check for. Is the text box format set to Currency or
at least numeric with 2 decimal places? Do you have the box formatted.
Check the format if you do. Is the fields data type in the table set
properly?
 
For example I have a form that has a maintenance code and then an amount to
go with that at the bottom I have a tax box and an invoice amount. All of my
amounts are working correctly except for my tax box. For example I want it to
show $24.20 and it will only show $24.00. I can't find any difference in the
propoerties compared to my other ones that are not rounding. Any suggestions
would be a big help.

Thanks,
Kelli
Click to expand...

My guess is that you have this field bound to a Number type field,
using the default Long Integer datatype. Integers are wholenumbers by
definition.

Check the table definition and change the datatype of this field from
Number to Currency (the Format and Decimals properties are irrelevant,
they just control data display not storage).

John W. Vinson[MVP]
 
Back
Top