D
dlazenby
I am trying to concatenate text boxes that contain different expressions and
am clueless.
My current issue is concatenating the values of 1) an option group with 2) a
field that is setup as a checkbox.
For example FieldA is for the option group. FieldB is for the checkbox.
For my report, my textbox expression with the option group is:
=Choose([FieldA], "breast biopsy", "lumpectomy", "mastectomy", "simple
mastectomy").
my textbox expression for the field with the checkbox is:
=IIf([fieldB],"modifier 59",Null).
My question is how do I make it so that I can concatenate those 2 fields (so
that they are on the same line, with a single space). Ultimately, I may need
to connect 3 or more of these expressions.
It seems like the way to go would be to make it so that the "output/value"
of those expressions becomes a new simple field (each) and then I could use
my old ways of concatenating with the & sign or the + sign. If you can't
tell, I am a novice with structuring expressions and also working with VBA.
Please advise. Thanks.
am clueless.
My current issue is concatenating the values of 1) an option group with 2) a
field that is setup as a checkbox.
For example FieldA is for the option group. FieldB is for the checkbox.
For my report, my textbox expression with the option group is:
=Choose([FieldA], "breast biopsy", "lumpectomy", "mastectomy", "simple
mastectomy").
my textbox expression for the field with the checkbox is:
=IIf([fieldB],"modifier 59",Null).
My question is how do I make it so that I can concatenate those 2 fields (so
that they are on the same line, with a single space). Ultimately, I may need
to connect 3 or more of these expressions.
It seems like the way to go would be to make it so that the "output/value"
of those expressions becomes a new simple field (each) and then I could use
my old ways of concatenating with the & sign or the + sign. If you can't
tell, I am a novice with structuring expressions and also working with VBA.
Please advise. Thanks.