Dynamic decimal places

[Kozbot]

Is it possible for a report's displayed decimal places to be conditional.

I have field that has a lab test's name a field that displays the result of the test.

For some tests I only want 2 decimal places, for others I want 4. Is this possible within the same field?

 

[pbaldy]

Untested, but I would expect that code in the detail section's format event could set that property dependent on whatever your conditions are.

 

[plog]

If pbaldy's suggestion doesn't work, this is absolutely possible in a query using an Iif statement nested in a Format(http://www.techonthenet.com/access/functions/numeric/format.php) function.

Provide sample data along with table and field names and expected results based on that sample data for more specific help.