substitute ( YourCheckBoxField ; ¶ ; ", " )
"¶"? What is this character? or is it a function key? Do you mean use the semi colon between the values in the value list instead of using the carriage return? Or should I be using a table for the check box values?
It is a pilcrow character - when you define a calculation you will see it is one of the buttons alongside the set of +, -, *, > etc characters. You can click that button and then copy the character. Or you could just copy the character that Phil has included in his reply.
Check box values are separated by that return character, so Phil is replacing every return with a comma and a space. So instead of the list looking like:
it will look like
MedA, MedB, MedC, MedD
I'm lost. How do I create or format the value list? Where am I substituting what Phil included?
Should it look like this? "Med A" ; ¶ ; "Med B" ; ¶ ; ", " etc?
Thanks to all of you! I have added the calculation fields on my "reports" it has simplified so much in the overall design.
PhilModJunk, DasSaint and Sorbsbuster!