Columns setup

In this article

Display Tab


This is the column header.

Header 2
This header is used by the program for only a few fields (e.g. Amount column).

This is the description of the field. This description will be shown as a tooltip.

This is the format to show numbers, date and time (see chapter at the end of this page).

This section defines the horizontal size of the column.

Column Style
This is a drop-down menu that indicates the style to be used (Format, menu, see sub chapters). This style has priority over the style of the row.

The user can choose whether to align the text right, left or center in this drop-down menu.

Wrap text
This option allows the user to view the input text on more than one line.

This option allows the user to protect the entire column so that no data can be input or edited.

Exclude from printing
When this option is activated, the field will be excluded from printing.

This option allows the user to make column visible.

The tables can be altered. Fields can be added, headers can be changed, and column sizes and the order in which they are shown can be altered.

Move up, Move down
The fields are listed in the order in which they appear on the table being used. The visible fields are the ones with a checkmark.
In order to alter the order in which they appear simply select the field you wish to move and drag it up or down.

This button adds new fields (columns) to the current table. Field added by the user are just information fields; the program does not make any calculation on numeric data.

This function is used to delete a field (column) from the list. A system field, however, cannot be deleted.


Settings Tab

Field name
This is the name of the active field and it is automatically inserted by the program. It cannot be modified.

Field name Xml
This is the name of the active field in the Xml format and it is automatically inserted by the program. It cannot be modified.

Data type
It is possible to choose between the following predefined types: Text, Number, Amount, Date, Time.

Max and Min length
Maximun and minimum field length.

Max and Min Value
It is possible to enter minimum and maximum values (numbers or characters).

Decimal points
It is possible to define the field decimal points

Field number
This is a number automatically given to the field, and has uniquely a technical purpose.

All caps
By clicking this options all fields data will be shown in caps characters.


Date, hour and number format

When the format is modified, the way the date, time and numbers are shown, changes.

If no specific format is specified, the default format of your operating system will be used (date, time and numbers as indicated on the control panel).

In the Format area of the Set up fields/Edit attributes command (Data menu) the user can use other formats. Types of formats, with some examples, are listed below:


Date format

Examples for date

d mm yy

1 01 15

dd m yy

01 1 15

ddd mmm yyyy

Fri Jan 2015

dddd mmmm yyyy

Friday January 2015

The letter “d” (day) indicates the day, the “m” (month) indicates the month, and the “y” (year) indicates the year.


Time format

Examples for time





Naturally the user can also invert the order of the elements making up the date or the time as desired (e.g.: mm dd yyyy).

As far as the separators are concerned, the user can choose between all of those available on the keyboard (for example: #, @, -, /, ., etc.).


Numbers Format

Example for numbers







The number of decimal spaces in a number field can be edited according to the user’s needs. Actual calculations are made using all the inserted decimal numbers. Rounding is only done for what is shown on screen.

This documentation is outdated

Search in the latest documentation

The feature you are looking for is missing? Try the new version! Banana Accounting 9

Share this article: Twitter | Facebook | LinkedIn | Email