Custom Format (Decimal Places)

[jkirkland]

My custom format for the textboxes on my report is:
#,###;(#,###);-;-

The problem is that some records have decimals, which I want to show, but most are whole numbers and I don't want the whole numbers to show trailing zeroes.

The 'General Number' format works fine except for 0 and null values, both of which I would like to show with the minus (-) symbol.

Any suggestions are appreciated.

 

[Blorf]

Can you change your format with the on format event?

Mabe something like if myval <> int(myval) then format = this, else that?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.