[MSAccessProfessionals] Conditional Number formating

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

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116717) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_