VERIFIED SOLUTION i
X

Labeling with an expression using the Format function in MapInfo Professional

UPDATED: April 19, 2017


When labeling with an expression on an Integer field, the commas disappear from numeric data. How can the numeric data be displayed with commas?

When labeling with multiple columns(expression), the numeric column information is changed to a string, thus losing numeric formatting. To restore the numeric formatting, use the format function.

Format$(Numeric_column_name, ",#") returns 1,234
Format$(Numeric_column_name, "$,#.##") returns: $1,234.56

Example below:

FCC ID Table Structure type is Integer and originally labeled with commas. When adding multiple columns with expression drops the comma. This is how to add the commas back to show in label.


Format$(FCCID, ",#") + Chr$(13)+ "FCC ID"

User-added image

Once applied, commas show correctly in label:
User-added image

Downloads

  • No Downloads