Access 2016. Hello. Im trying to display a number from an expression in fixed format (2). I’m trying to get a fixed decimal (2) format generated from: z: IIf(IsNull([Field1]),"NM",[Field1]). When I just query on Field1, I correctly get (example) “10.00”. The expression works as intended, but I get a “10” instead of the 10.00. Field is Number, Double, Fixed (2) with a default = null/blank. Full Disclosure: Novice.