Allowing or preventing entry into fields

1. In Layout mode, select one or more fields.

2. In the Inspector, click the Data tab.

3. In the Behavior area, for Field entry behavior, choose one of the following options for In Browse mode and In Find mode:

   • To allow users to modify the data in the field, choose Edit.

   • To allow users to select and copy the data in the field but prevent them from editing the data, choose Select Only.

   • To prevent field entry and allow users to only view the data, choose View Only.

   • To use a calculation to allow or prevent field entry, choose Set by Calculation. Then enter a numeric expression for one of these values:

     • 1 for Edit

     • 2 for Select Only

     • Any other value for View Only

4. To select the contents when the field is entered, select the Select contents on entry checkbox.

Notes 

• Preventing entry into a field only affects the field object on that layout. To always restrict access to a field on any layout of the database, define a privilege set to permit "view only" field access for that field. See Managing security.

• If you set both In Browse mode and In Find mode to Set by Calculation, you can specify a calculation that returns a different value when in each mode by using the Get(WindowMode) function. For example:

  Copy

  Case ( 
      Get ( WindowMode ) = 0 ; 2 ; // In Browse mode, allow Select Only.
      Get ( WindowMode ) = 1 ; 1 ; // In Find mode, allow Edit.
      0                            // Otherwise, allow View Only.
  )