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 (thi...
- 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.
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.
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.
