MYOB Greentree

HideShow

  • Contents
  • Index
  • Search
 
Display results with all search words

 

Field Properties


The properties for a field can be accessed either by double clicking on the field or by clicking the hand icon icon on the toolbar while on the field. Some properties differ depending on the type of field, but these properties/options are the same for all fields:

Field Properties Header

The header of each field property form contains a combo box control displaying all report properties within each respective section. Selecting a field property from the list will highlight it on the report. Once the field is highlighted, standard property maintenance can be applied .

A Select Control form can be launched using the arrow icon positioned to the left of the property combo box. This expands the view of the section field properties.

Style

These properties relate to the physical format of the field. Most of the options are also available on the baseline toolbar. Additional options on this form include a Border option, which enables you to select a border type (select None for no border, or a number depending on the thickness of the border required) and a Stretch option. The stretch option is available if an image field is selected and these options are available:

  • None - Displays the image the same height and width as the original, but will cut off parts of the image that do not fit within the box.
  • On - This will stretch or shrink the image to fit precisely inside the box around the image resizes to fit even if original image proportions are lost in the process).
  • Proportional - This will stretch or shrink the image to fit within the box. The image is kept in it's original proportion.

    The arrows in the Position section can be used to nudge the field in various directions if you want to re-position the field.

Format

These properties relate to the value format of the field. Several pre-defined formats are available to select, each with related properties:

  • None - If this option is selected, no special format applies to the field.
  • Numeric - If this option is selected, the field will have a numeric format, and these options may be further defined:
    • Negative style - Select Negative sign or Brackets as the preferred option to express negative values for the field.
    • Sign - Select Normal, Negate or Always Positive as the preferred option to express field values.
    • Display decimal places - Select the number of decimal places you want to display for the field.
    • Display this currency symbol - Enter a current symbol to display one as a prefix to the field value.
    • Pad to x characters with this symbol - If you want to pad a number to a specific length, use this option. For example, if you enter Pad to:10 with symbol #, then the value 12.25 will be expressed as #####12.25.

      Information decimal punctuations and comma thousand separators (if option selected) are included in the total pad width. For example, the value 31254876 will appear as 31,254,876.

    • Don't display the decimal point - If selected, no decimal point displays for numbers that would normally show decimals.
    • Don't display anything if zero - If selected, field values = zero will not display.
    • Include commas - Select this option if you want field values to show commas as thousand separators.
  • Date - If this option is selected, the field will have a date format, and these options may be further defined.

    Select a Short date or Long date format, or select Enter a format to specify a user-defined format for the date field using the available date flags displayed on the form. For example, the short date format displays 3/20/2018 which is in the format M/dd/yyyy. If you want to display the day first, you can enter a format of: dd/MM/yyyy, or similar.

  • True/false - If this option is selected, the field will have a boolean format, and these options may be further defined:

    You can select one of five pre-defined true/false styles. The text that displays in the field uses the style that is selected — for example, if Yes/No is selected, then Yes displays when the value of the field is selected and No displays when the value of the field is false. The Text for true and Text for false fields update with the relevant text as the style is selected, except where Custom is selected, in which case you can enter your own text to display in the field to represent true and false values.

  • Time - If this option is selected, the field will have a time format, and these options may be further defined.

    Select either 12 or 24 hour clock as the preferred option to display the time in the field.