Previous Topic

Next Topic

Data Entry Controls

Data is entered in fields known as Data Entry controls. Different types of Data Entry Controls allow you to enter and select data in different ways.

Standard Edit Control

Type text in the field.

Lookup Control

Enter text or select from a list of values. The value entered must be valid in the database. See Accredo Lookups.

Calculator Edit

Type the number, or click Calculator (F2). The result of calculations will be displayed in the control.

Spin Edit

Accepts numbers when there is a specified range of legitimate values. You can type numbers, or click the arrows to increment or decrement, or press (+) or (-) on the numeric keypad.

Enumerated Lookup

Select from a pre-defined list. You can use the same methods as for the lookup control.

Date

You can type a date in the field, or click the Control calendar Calendar (F2) to select a date. Information entered in Date fields is always interpreted as a date. The default format for date fields is the Short Date set in your Windows Settings.

You can type any of the following in a date control field to obtain the above example:

  • 300915
  • 30 Sep 15
  • 30/9/15
  • 3--9-15

If you do not enter a year or month, they will be sourced from the System Date. For example, if you type 16 in the date control on a day in May 2018, it is interpreted as 16-May-2018. Press (+) or (-) on the numeric keypad to step dates forwards or backwards one day at a time. Press (Ctrl++) or (Ctrl+-) on the numeric keypad to step dates forwards or backwards one month at a time.

Dates from 1/1/1800 are valid, except for 31/12/1899, which is the Null date, and cannot be entered.

Press + on the numeric keypad in a blank date field to enter the current date.

Time

You can enter a time in a time field, or drop down to select a time on the half hour.

Press + on the numeric keypad in a blank time field to enter the current time.

Checkbox

Select a boolean value (such as Yes/No or On/Off). Click or press the Space Bar to toggle.

See Also

Global Tools

Book Contents

Book Index