I have created a form that has a multi-line concatenated string. My expression reads as follows:
=([CovType1] & " - "+[Results1] & " - "+[Details1] & "
") & ([CovType2] & " - "+[Results2] & " - "+[Details2] & "
") & ([CovType3] & " - "+[Results3] & " - "+[Details3] & "
") & ([CovType4] & " - "+[Results4] & " - "+[Details4])
The fields CovType1, CovType2, etc all are part of a drop down list where the user selects one of several options. Each option in the drop down list is a word, and there are no numbers included.
When I run the form, the CovType field in each line returns a number. The Results and Details fields all return the content that is supposed to be included.
Can anyone help me please get the CovType field to properly display the content it is supposed to?