Promotic
WikipediaLinkedInYoutubeTwitterFacebook

LabelBorderFormat - property of object tvScale

Description:
Format of scale edge legends.
Syntax:
LabelBorderFormat As Variant
Calling:
oScale.LabelBorderFormat = format
Note:
Property access for read and write. The preset value of this property is defined in the LabelBorderFormat configurator of this object. Drawing the scale legends proceeds according to this property setting, only when the value oTrend.LabelBorderFormat="$dbind" is set in the tvTrend.LabelBorderFormat property (by tvTrend.LabelBorderFormat property otherwise).
 
Setting this property differs according to setting the LabelBorderFormatType property:
If LabelBorderFormatType=0, then the legent is a numeric value, with the accuracy defined in LabelBorderFormat meaning the number of valid digits of the difference between tvTrend.ValueMax and tvTrend.ValueMin.
If LabelBorderFormatType=1, then the legend is a numeric value and the number of decimal places is set into the LabelBorderFormat.
If LabelBorderFormatType=10, then the legend is a time and the format formula is set into the LabelBorderFormat in the form, for example, "%d.%m.%Y %H:%M:%S.%T" where:
d=day (1-31),
m=month (1-12),
Y=year (e.g. 2016),
H=hour,
M=minute,
S=second,
T=millisecond (0-999) - it is possible %nT, where n is count of figures 1, 2 or 3
.

If the legend has to be divided into more lines, it is necessary to enter "new line" character (vbLf constant) into the string.

Default value at the value scale is 1 (i.e. 1 decimal place), at the time scale it is the string "%d.%m.%Y" & vbLf & "%H:%M:%S".

Example1:
Legends of the value scale edges are numeric values to 2 decimal places. Legends of the time scale edges are a time with the format: day.month.year NewLine hour:minute:second.
oTView.ScaleValue.LabelBorderFormat = 2
oTView.ScaleTime.LabelBorderFormat = "%d.%m.%Y" & vbLf &"%H:%M:%S"
Example2:
Legends of the time scale adges are in the time format: day.month.year NewLine hour:minute:second.millisecond (millisecond is on 2 places).
oTView.ScaleTime.LabelBorderFormat = "%d.%m.%Y" & vbLf &"%H:%M:%S.%2T"
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice