Database Field Properties

		Each field, page and table has a set of properties, or characteristics, which dictate how the field appears and what information it can hold.
		Prompt
		This is what appears next to the field, on the page tab, or for database tables what appears as the column title.
		Administrator access only
		If set to True, only the Administrator can change the contents of the field. If set to False, any user can change the contents of the field.
		Appearance
		Textbox	Up to 64k of information can be entered into the box.
		Drop-list	When the user clicks the field, a list of choices will appear. The user may either choose one or more of the existing list items or enter an alternative. (see Drop-List: Can enter text, Drop-list: Choices and Drop-List: Multiple selections)
		Calendar	When the user clicks the field, a pop-up calendar will appear. (see Formatting)
		Number	Only numbers can be entered into the box. (see Formatting)
		Sage® Link	If the user enters a Sage® account number into the field, they will see the corresponding Sage® field displayed instead. (see Formatting)
		Filing Reference	When the user clicks the field, the Search box will appear and a link to another company or contact can be established. (see Formatting)
		Tickbox	The field will appear as a tickbox, followed by an optional caption. (see Formatting)
		Available in mail-merge
		IIf set to True, the field will be shown as a choice when composing a mail-merge document in Word®.
		Background colour
		Allows you to colour-code the fields or draw attention to particular fields, such as field which should not be left blank.
		Drop-list: Can enter text
		If set to True and Appearance is set to Drop-list, the user can either select an item from the list of choices or enter an alternative. (Alternatives are not permanently added to the list) If set to False and Appearance is set to Drop-list, the user must select an item from the list of choices or nothing at all.
		Drop-list: Choices
		Allows you to edit the list of choices which appears if Appearance is set to Drop-list. The list will appear in the same order as they appear here. Double-click on Drop-list: Choices to edit the list Click the Add button to add a new item (New items are added in their sorted position) Click the Delete button to remove highlighted items (You can make a multiple selection) Use Up and Down to move items around To return to the field properties page, click the Return to properties page button.
		Note You can populate the list of choices from other drop-lists, or from Clipboard, by clicking the Add list items from... button
		Drop-list: Multiple selections
		If set to True and Appearance is set to Drop-list, the user can select any number (or no) items from the list of choices. If set to False and Appearance is set to Drop-List, the user can only select one (or no) item from the list of choices.
		Float-over help
		The text that you enter here will appear as a tool-top box when the user clicks on or floats over the field. Long descriptions may be truncated.
		Formatting
		If Appearance is set to Calendar, Number, Sage® Link, Filing reference or Tickbox, the formatting property dictates how the data will be displayed. In the case of a Sage® Link, the user enters the Sage® account number in the field and the formatting property dictates which Sage® field will be displayed in its place.
		Note: Formatting is removed when the user clicks on a field and then reapplied when the user moves to another field.
		Hidden / unused
		If set to True, the field or table column is hidden If set to False, the field or table column is visible To show and hide entire pages, see Contexts
		HTML tag
		All fields can be included wherever HTML documents are created automatically by the program (when creating Jobsheets for example). The HTML tag value is what you enter in your HTML document wherever you want the field value to appear.
		Mail-merge tag
		All fields can be included wherever Word® documents are created automatically by the program (when doing Write a letter for example). The Mail-merge tag value is what you enter in your Word® document wherever you want the field value to appear.
		Show in 'Quick new contact'
		If set to True, this field will appear when entering details in the Quick new contact screen.
		Column 1-5: Last row caption
		Sets the caption which appears in the column on the last row of a database table. Eg. Total
		Column 1-5: Last row content
		Sets the value which appears below the Last row caption in the column.
		Note: The column must contain only numerical data if you want to display Last row content.
		Related topics Linking with Sage®