Re: [MSAccessProfessionals] Conditional Number formating

The solution I have seen at a former employer was to have a second field to store the precision (# of decimal places). 

Duane

Sent from my mobile

On Dec 5, 2025, at 9:18 AM, Jane via groups.io <jcross=crossproducts.plus.com@groups.io> wrote:



Hi

I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 

eg 

User Enters	Currently Displays	Required Display
10.50	10.5	10.50
11	11	11
10.0	10	10.0

 

Any suggestions?

Many thanks

Jane