Custom Field Format to display Refraction Data

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-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?
Question by:isurgyn
  • 2
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 36958090
"I have tried using the same custom formating as an input mask on the form"
Seems you would want to use the Format property, not the Input Mask ...


Author Closing Comment

ID: 36958778
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.
LVL 75
ID: 36958799
You are welcome. Seemed like the right answer :-)


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question