A dollars-only field will allow only the dollars portion of a currency amount to be entered. It formats the value with comma separators for thousands, millions, billions, etc.
A dollars-only field is always coupled with a cents-only field found to its right. Together these two fields represent a single currency value. Usually a vertical line on the form separates them
Entry:
To enter a value make sure the entire value is selected. Enter the dollar digits of the amount from left to right. Then press Tab (or Enter) to move to the cents-only field found to its right.
Note that when a field is first activated the entire value will be selected by default. So usually you will not need to select the entire value before entering the new value.
The entire value is selected if all of its digits are highlighted in blue. To select the value when it is not currently highlighted just double click inside the field. You can also select the value using the keyboard by first pressing the Home key, then pressing the Shift + End key combination.
To replace the current value first select the entire value, then enter the new value as instructed above.
To change only a single digit in the value, position the cursor to the left of that digit, then enter the new digit. The cursor can be positioned using either the arrow keys or a mouse click.
To empty the value, select the entire value, then press the Backspace key or the Delete key. This will result in a zero value for this amount field.
To restore the original value use Undo command on the Edit menu, or by pressing the Ctrl+Z key combination. This undo will revert back to the original value. Use undo again to restore the new value.
If this field is calculated then you will not be able to edit it directly. A calculated field has a different color than an entry field. When active a calculated field is gray and does not accept entries, while an editable field is white and does accept entries. For more information on editing calculated fields click here.
Note that normally the cents portion of the amount must be entered in the cents-only field to this field’s right. But you can enter the dollars and cent portion of a value in the dollars-only field if you wish. To do this check Edit Cents in Dollars-Only Fields item on the Options, Field Defaults menu. By default this is not checked. When checked this dollars-only field will act exactly like a currency field when it is active and when editing it.
Navigation:
To move to the next field on this page press either the Tab or the Enter key. For more on navigating the fields of a page click here.
Available operations:
If the Drill Down button is enabled for this field then pressing this button will take you to the field from which the active field’s value is calculated. For more information on the drill down operation click here.
If the Drill Up button is enabled for this field then pressing this button will take you to the summary field where this field’s value is carried. For more information on the drill up operation click here.
If the Add Field Worksheet button is enabled then this field has worksheets that can be attached and used to calculate its value. Currency fields almost always have the Details Worksheet available. But for some fields custom worksheets can be attached to assist in calculating complex values.
Note that the worksheets available for the active field will also be shown in the Attachments List part of the Table of Contents pane.
If a worksheet is already attached for this field then pressing the Add Field Worksheet button will inform you of this and will ask if you want to open that worksheet.
Grid row operations:
If this field is in a grid row, then the row operation buttons will be enabled on the Field Actions toolbar shown along the right of the screen. These buttons provide quick access to all grid row operations such as:
For more information on working with grids click here.
Field Formatting:
The formatting of this field can be adjusted by the user. All of the formatting options of a single line text field can be used for dollars-only fields. These common format options include the font, text alignment to name a few. There are also special formatting options for dollars-only fields like the ability to show or hide zero amounts. For more information on changing a field’s appearance click here.
Other:
This topic is shown when the More button is pressed on the Brief Help pane. It is also shown when a field on the page is clicked with the Help Cursor.
If the Brief Help pane is not showing then you should open and review its text for two reasons. 1) There may be custom instructions for this field that are shown only in the Brief Help pane. 2) The Brief Help pane will show text that describes the state of the active field, while the help system can not detect a field’s state.