home « support « FAQ « decimal places

How can I make my DFA results for time and cost show additional decimal places?

You can increase or decrease decimal display in DFA by editing the file blank.dfa in MS Access 2000 or later. do the following:

  1. Shut down DFA.

  2. Follow these precautions:

    • Save a copy of the file blank.dfa, located in the System folder of your DFA installation, in a location such as My Documents in case you later wish to replace the file you are about to change with the original. You can use Windows Explorer or your preferred file management software to locate, copy and save this file.

    • When following the steps below, don't edit the SizeMask field if it is empty or contains a number. Only edit the ones with #'s.

    • When following the steps below, don't add or delete any records from this table.

  3. Run Microsoft Access.

  4. Choose File-->Open and navigate to the System folder of the program group where DFA is installed, DFMA by default.

  5. Change the Type dropdown in the Open dialog to All files.

  6. Find the file blank.dfa. This is the template for new analyses in DFA.

  7. Open blank.dfa with Access.

  8. See that the Access Object is Tables.

  9. From the Table list, choose FieldInfo and double-click to open it.

  10. The FieldInfo table contains the results and responses fields, including a column SizeMask.

  11. SizeMask consists of formatting such as ####.##

  12. You can edit these masks, including extending the decimal display as necessary.

  13. Choose a field whose mask you want to change, such as the label Total labor time.

  14. Change its SizeMask column from #######.## to #######.####. This will cause the decimal display for Labor time in the Results to show four decimal places instead of 2.

  15. You can change other field masks in a similar way.

  16. Close Access after making the changes you want, and run DFA. The results for Labor time now show decimal places to 4.

  17. You can always replace a blank.dfa file that you have altered with the saved copy of the default blank.dfa.