Tip for Access 2007: Use “Check for Truncated Number Fields” for Partially Displayed Numerical Values

In Access 2003 or earlier, you may have seen truncated numbers on forms or reports, and not realized that you weren’t seeing the full value. Access 2007 includes a new option tocheck for truncated number fields and display pound signs (#) to indicate that the entire value is not shown.