Bombshell Disaster
Registered User.
- Local time
- Today, 10:34
- Joined
- Nov 21, 2007
- Messages
- 32
Hi All
I am trying to concatenate 13 checkboxes into a text field for reporting.
I know that I can add the following to the ControlSource ID on a text box in the report.
Though what I am wanting to test is the following, but can't get the syntax to join on to the previous value:
I think what I need to do in the code window is to make a string that will concatenate the fields with a ", " if the checkbox is = True
Can anyone point me in the right direction.
Many thanks...
I am trying to concatenate 13 checkboxes into a text field for reporting.
I know that I can add the following to the ControlSource ID on a text box in the report.
Code:
=[BloodTest] & (", " + [BowelPrep]) & (", " + [DietReq]) & (", " + [MedReq])
Though what I am wanting to test is the following, but can't get the syntax to join on to the previous value:
Code:
=IIf([BloodTest]=True,"Blood Test",IIf([BowelPrep]=True,", BowelPrep"))
I think what I need to do in the code window is to make a string that will concatenate the fields with a ", " if the checkbox is = True
Can anyone point me in the right direction.
Many thanks...