Layout Property Format

The layout property Format can be used in Labels and Editboxes to specify how the value is shown on a form.

The following characters are available to be used in format:

Character:	Meaning:
$	Adds a currency sign in front of the value. When used concurrently, suppresses leading zeroes and moves the Currency sign directly in front of the first non zero number. Example: `Value 0012,95 with format $99999.99 results in $00012.95 Value 0012,95 with format $ZZZZ9.99 results in $ 12.95 Value 0012,95 with format $$$$$9.99 results in $12.95`
B	Adds a blank space on the location it is inserted. Example: `Value 8675309 with format 999B9999 results in 867 5309`
' ' (space)	A space adds a blank space on the location it is inserted, the same meaning as B. Example: `Value 8675309 with format 999 9999 results in 867 5309`
Z	Suppresses leading zeroes.
9	Numeric
X	Alphanumeric
/	Adds a slash on the location it is inserted.
:	Adds a colon on the location it is inserted.
-	Sign location, when negative '-' else ' '
+	Sign location, when positive '+' else '-'
CR	Credit sign location, when positive then ' ' else 'CR'
DB	Debit sign location, when positive then ' ' else 'DB'
*	Replaces leading zeroes with asterisks.
!	When placed at the front and the value is zero then the result will be blank.

Contents