>>The cool trick I like to use for this kind of thing is to use the following in the field expression box:
>>IIF(field=value,substitute_value,field)
>>HTH
>
> Yeah, that's what I'm doing in another one of my reports. Unfortunately, this field can be one of ten different values.
Hey, first of all, there is a Print Option on Field.
Double-Click the field and click the Print Option, and fill in the condition.
Previously, I have a problem on printing 10 selected option on FIX label text.
Such as 'Need Throw Test', 'Add Client Label', .....
If I put them one by one, the figure will like below:
.........
.........
.........
.........
.........
.........
This layout will be very poor.
So, In order to shorten the IIF() statement.
I define some variables in report by: (Select Variable in Report menu)
L1 = "Need Throw Test"
L2a = ...
Finally, I make a huge rectangle field for puting multi-line.
IIF(Cond1, L1+CHR(13), [])+IIF(Cond2, L2a, L2b)+Chr(13)+.....So, this field total character will
NOT be excess 255 characters.
and the layout will be well
hor. PACK!! ^_~
Hope this can help your 10 different values...
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.