Multiple value field displaying number instead of what is in the table

  • Thread starter queenz_d via AccessMonster.com
  • Start date
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top