Conditional decimal places?

[Dave66]

I have a database that requires a particular field to have varying decimal places (1 or 2) based on a value in another field. This data will be used in calculations and exported to Excel for graphing so the text format is not an option. Is there a way to set this up in the table or have it format properly in a report?

 

[llkhoutx]

Exporting to Excel and reporting format are two entirely different things.

Data in a table or query is just data, that is the data which is exported. However, it can be conditionally formatted when reported.

To conditionally format in a report, use the report's detail section Onformat event:

if Me!field1 = 'some condition' then
me!field2.DecimalPlaces=1
else
me!field2.DecimalPlaces=2
end if