Formatting Values in Sentences

Sometimes, you need to call a field in a sentence, but maintain the proper formatting.  Depending on the type of value you are calling, sometimes the formatting will not appear how you want.

For example, if you wanted to state that “Sales to Mark’s Produce account for 2.4% of total sales” you would need to use this formatting style:  Format([FieldName],”Percent”)

Proper syntax:  “Sales to Mark’s Produce account for ” & Format([FieldName],”Percent”) & ” of total sales.”  Using this syntax, the resulting sentence would appear this way:  “Sales to Mark’s Produce account for 2.4% of total sales.

Improper Syntax:  “Sales to Mark’s Produce account for ” & [FieldName] & ” of all sales.”  Not including the appropriate formatting code would result in the sentence looking like this:  Sales to Mark’s Produce account for 0.024 of all sales.