Custom Field Format to display Refraction Data
Posted on 2011-10-12
I am needing to display a number field on a form that is used in medical eye care. The number corresponds to the spherical correction in a pair of glasses. The number needs to display a + sign if the value is positive and a negative sign if the value is negative. If the value is zero it needs to default to the word "plano" and if the field is null display nothing. It should also be fixed at 2 decimal points.
The following field format works perfectly in the database table. However, the form is based on a query and the formating does not display in the form.
I have tried using the same custom formating as an input mask on the form but that doesn't work.
The database we are using is Acess 2007 front end and MS SQL Server 2008 back end. Any way to do this?