Translating special characters
We need to ensure that the labels of the combo boxes are translated if a user changes the report language. But special characters such as the colon (:) present a problem because the colon does not form part of the strings in the Table of Names and Texts.
For example, in cell B6, the label, Measure is translated if the report language is changed to German. But if we insert a colon after Measure, the string will not be translated.
The incorrect solution would be to change Measure in the Table of Names and Texts to Measure, or to have two versions of each string, one with and one without the colon.
Here is the correct solution: