Q
queenz_d via AccessMonster.com
I have two columns on my report.
One column named Loss Category that is bound by the field Loss Category on my
table and is set up as a combo box that allows multiple values to be selected
on the form. For example, a user may select fraud or personal injury OR
fraud and personal injury.
The second column on my report is named Risk Information that has the
following expression:
RiskInfo: "Loss Date: " & Chr(13) & Chr(10) & [Loss Date] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & "Insurance Defense:" & Chr(13) & Chr(10) & [Insurance
Defense]
When I run my report, this everything works fine. However, to save space on
the report and make it more concise, I would like to report Loss Category
under RiskInfo as well. I tried the following expression:
RiskInfo: "Loss Category:" & Chr(13) & Chr(10) & [Loss Category] & Chr(13) &
Chr(10) & Chr(13) & Chr(10) & "Loss Date: " & Chr(13) & Chr(10) & [Loss Date]
& Chr(13) & Chr(10) & Chr(13) & Chr(10) & "Insurance Defense:" & Chr(13) &
Chr(10) & [Insurance Defense]
This time, instead of the Loss Category items in my table, I am getting a
number. Please advise how I can display just what is selected in the table.
Thanking you ahead!
One column named Loss Category that is bound by the field Loss Category on my
table and is set up as a combo box that allows multiple values to be selected
on the form. For example, a user may select fraud or personal injury OR
fraud and personal injury.
The second column on my report is named Risk Information that has the
following expression:
RiskInfo: "Loss Date: " & Chr(13) & Chr(10) & [Loss Date] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & "Insurance Defense:" & Chr(13) & Chr(10) & [Insurance
Defense]
When I run my report, this everything works fine. However, to save space on
the report and make it more concise, I would like to report Loss Category
under RiskInfo as well. I tried the following expression:
RiskInfo: "Loss Category:" & Chr(13) & Chr(10) & [Loss Category] & Chr(13) &
Chr(10) & Chr(13) & Chr(10) & "Loss Date: " & Chr(13) & Chr(10) & [Loss Date]
& Chr(13) & Chr(10) & Chr(13) & Chr(10) & "Insurance Defense:" & Chr(13) &
Chr(10) & [Insurance Defense]
This time, instead of the Loss Category items in my table, I am getting a
number. Please advise how I can display just what is selected in the table.
Thanking you ahead!