asked on

Custom Field Format to display Refraction Data

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.

+#.00;-#.00;"plano";""

The database we are using is Acess 2007 front end and MS SQL Server 2008 back end. Any way to do this?

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

isurgyn

ASKER

OK that was just too easy. I guess I was confused by the Format property having a drop down and assumed those were the only options...ie General, Currency, Percent, Euro etc.

So to solve the problem just type the format that I had configured into the Format property of the field on the form and it works great.

Thanks as million.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

You are welcome. Seemed like the right answer :-)

mx