This section describes peculiarities of work with some types of record fields. You can change appearance and behaviour of fields using the Form Editor.
Simple Text Field
The content of this field can be highlighted red if for this field a mask is specified and it does not correspond to the entered text. For example, if mask "###-##" is specified (three digits, a dash and three digits) and only 2 digits are entered, such text will be highlighted red and the value will not be saved.
At editing a field with a mask, the program will automatically enter necessary characters and block not permissible ones. In the example above, once 3 digits are entered, the program will enter a dash and will not allow entering a letter.
If for this field the 'Dynamic' type is set, the formula used in it can be specified independently for every record. To change the formula for the current record, double-click a field. At that, the Formula Editor will be opened.
To change the date, double-click the date field:
The yellow color shows the current date, while the red color stands for the selected date.
Drop-down Combo Field
For this field, changing of possible values in the list can be allowed. In this case:
The content of the list can depend on the content of another list, for example, Car Make - Model or State-City.
Multi-line Text Field
If 'Spell Check' is selected for this field, then, in case there are words, that are absent in the standard dictionary, in the text, a special window will be displayed once the text is entered:
This field allows you to select a number of values from the list. To add or remove a value, just click it.
This field looks like a usual field for storing text. However, if you enter text there and press 'Enter', a specified script will be executed (for example, searching for records or adding in the order goods by the specified number). Learn more about Text Buttons...
To get access to the image menu, right-click an image:
This field can store any files within. At that, the database will store not a link to the file, but the file itself. That is, adding a file extends the size of the database file.
On clicking the field:
To access additional functions, right-click the field:
Rich-text Field (RTF)
At work with this field, a special panel for formatting and changing properties of the selected text fragment will be displayed:
Left to right:
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.