automaticaly change a part of expression in a number of a report's control values
#1 in my report i need to group my clients and print a color code "Green", "Red" and "Blue" above names of the clients depending on values in the order form. Is it possible to print it from the single textbox (right now I have 3 textboxes with
Code:
=IIf([Day1]=1, "Green")
in first one.
Code:
=IIf([Day1]=2, "Red")
in second box etc. Which makes printout look very bad.