9.0

266
Format User Defined Text
Description
The following text formats may be used with the Format function. Text formats may be combined to create the user
defined text format. User defined text formats may not be combined with other user defined formats or predefined
formats.
User defined text formats can contain one or two sections separated by ';':
form - format for all strings
form;nullform - nullform: format for empty and null strings
Parameter Description
@ char placeholder, insert char or space
& char placeholder, insert char or nothing
< all chars lowercase
> all chars uppercase
! fill placeholder from left-to-right (default is right-to-left)
\c insert character c
"text" insert literal text
Example
Sub Main
Debug
.Print Format("123","ab@c") '" ab1c23"
Debug
.Print Format("123","!ab@c") '" ab3c"
End
Sub
Error List
The following table lists all error codes with the associated error text.
Error Description
10000 Execution interrupted.
10001 Out of memory.
10008 Invalid '#Uses "module" comment.
10009 Invalid '#Uses module dependency.
10010 Macro is already running.
10011 Can't allocate memory to macro/module.
10012 Macro/module has syntax errors.
10013 Macro/module does not exist.
10014 Another macro is paused and can't continue at this time.
10017 No macro is currently active.
10018 Sub/Function does not exist.
10019 Wrong number of parameters.
10021 Can't allocate large array.
10022 Array is not dimensioned.
10023 Array index out of range.
10024 Array lower bound is larger than upper bound.
10025 Array has a different number of indexes.
10030 User dialog has not been defined.
10031 User pressed cancel.
10032 User dialog item id is out of range.
10033 No UserDialog is currently displayed.