This article is outdated. Please see our Expression Guide and the topic on Formatting Text for more information.

• Referencing a field in the database is done using the following syntax [group.Header]. The group and header name are displayed in brackets in the properties interface. E.g. the following field would be referred to as [LocationDetails.ApprovedBy] The use of capital letters and the square brackets is important.
  
• To add numbers to a text expression you must wrap the value with the text() command.
• You can use the Fixed() command to fix the number of decimal places within the number before it is
• To add two strings together you can use the + operator and to add text to parameters the text must be in single quotes
• A Carriage return can be added to an expression using the '\n'
• The following expression shows all of these rules to show the Easting to 2DP followed by the let-ter E followed by a carriage return and then the Northing to 2DP followed by the letter N

text(fixed([LocationDetails.Easting], 2, false)) + 'E' + '\n' + text(fixed([Loca-tionDetails.Northing], 2, false)) + 'N'