Speaking of totals, how many times have you looked at a form or report and not realized that some of the digits were missing? It could be rather disconcerting, because Access did not provide an indication that the field was too narrow to display all of the digits. With Access 2007, you can retain that default behavior or set a new Access Option to Check for Truncated Number Fields. If that is selected, Access will fill the text box with pound signs rather than display a truncated number. This applies to text boxes on both forms and reports.
Was this article helpful?