Forum Discussion
Force Fixed Decimal - 6 places
Hello experts,
I am trying to force my field to use 6 decimal places but it seems to drop the zeros at the end. I have the field property set to "FIXED" and 6 decimals but it doesnt force 6 (this is at the rpt level since the query level doesnt allow me to choose 6).
How can I show 6 decimal points (basically show the zeros that are being dropped)?
ParentRateUseThis: Nz([qryFXRateLastUseThis].[Rate],[tblFXParent].[rate])
here is the ppty at query level. I chose Fixed but there is not a number of decimals option to choose.
here is the output:
you can see a few are <6 decimal points. In those cases, there is a 0 at the end but its being dropped.
thank you.
- as suggested don't use Fixed as your Format.
instead use 0.000000 as Format property on your Table (design view) or Form/Report, etc.
That's how numbers work.
The trailing 0's are meaningless and will not be displayed for numbers. It means that the values are accurate as far as the digits appear.
However, the real issue here is DISPLAY, as opposed to STORAGE, of values.
What you want is a DISPLAY that varies from the default. And that can be handled with a Format() expression which forces the display of meaningless 0's to pad out the length.
- as suggested don't use Fixed as your Format.
instead use 0.000000 as Format property on your Table (design view) or Form/Report, etc.Hi Arnel, that worked! I had to use it like this though:
Format(Nz([qryFXRateLastUseThis].[Rate],[tblFXParent].[rate]),"0.000000")thanks guys. Really appreciate it.
- LOL. That's what I suggested: Use Format.
