default value in numeric field

  • Thread starter Thread starter akling
  • Start date Start date
A

akling

I am trying to set a default value for a text box
containing a "Tax Rate". I have tried doing it with the
field set as a numeric and with the field set as a
percentage, neither are returning the results I need,
being either.... .0625 or 6.25%

Any suggestions???

My results have been as follows:

Format: General Number
Decimal Places: 4
Default Value: 0.0625

Text Field Displays : 0

Format: Percentage
Decimal Places: 4
Default Value: 0.0625

Text Field Displays : 0

Format: Percentage
Decimal Places: 4
Default Value: 6.25

Text Field Displays : 600%

Format: Percentage
Decimal Places: 4
Default Value: .625

Text Field Displays : 100%


Thanks in advance,

akling
 
Sounds like you've got the field size set as integer or long integer. An
integer is a whole number, you need to use a floating point field size such
as double.

(I've never understood why the decimal point property appears for integer
types. It only leads to confusion).

HTH
Sam
 
Back
Top