I am displaying the results of a database lookup in a calculated field. It all works well except in Display mode, where the string ";#" is appended to the end of the string in the calculated field control. (See image below.) Does anyone know why this happens and how to prevent it? I might expect this when the display format of the database lookup is "Dropdown Menu" since the ";#" separates the value and display components, but in this case the display format is "label" so I don't know where this string is coming from.
Solved! Go to Solution.
Um...I think I see the problem. The calculated control was set to recalculate on view mode. When I set this to "No" the extraneous characters disappear. This makes sense, in a way.
Thanks for the prompt reply.