Is there a way to call the value of the textbox with a function to change the background color in the fill property? I have a report with a series of textboxes. The value of the textboxes is based on the month and year in regards to the present. Each has a function in the value, the first textbox has: =MonthName(Month(Now()))&" "&Year(Now()) and gives the present month and year. Each of the following textboxes has a function similiar to: =MonthName(Month(DateAdd(DateInterval.Month, 1, now())))&" "& Year(DateAdd(DateInterval.Month, 1, now())) increasing the number of months up to 14 months in the future, i.e. April 2013, May 2013 etc.. For each textbox I would like to have the fill color based on the year shown in the value. For this year it would be blue, for next year it would be red, and for two years in the future, it would be green. I tried to do this with IIF() functions and other ways but it does not work Is there a way to do this?

Is there a way to call the value of the textbox with a function to change the background color in the fill property? I have a report with a series of textboxes. The value of the textboxes is based on the month and year in regards to the present. Each has a function in the value, the first textbox has: =MonthName(Month(Now()))&" "&Year(Now()) and gives the present month and year. Each of the following textboxes has a function similiar to: =MonthName(Month(DateAdd(DateInterval.Month, 1, now())))&" "& Year(DateAdd(DateInterval.Month, 1, now())) increasing the number of months up to 14 months in the future, i.e. April 2013, May 2013 etc.. For each textbox I would like to have the fill color based on the year shown in the value. For this year it would be blue, for next year it would be red, and for two years in the future, it would be green. I tried to do this with IIF() functions and other ways but it does not work Is there a way to do this?

You should be able to set the Background Color property using an IIF expression. What is the expression you used? Can you post it? The IIF expressions would have to be nested though. An easier approach that I prefer instead of nesting may IIF's is to use the SWITCH construct like below:

The value of the textbox does not come from a field but is generated by the function above. There is a row of textboxes each of which have the month and year in sequence starting with the present month that a user generates the report and going up to 14 months out. I need for the months in the current year to be one color, the months in the next year to be another color and the months in the year after that to be another color. I need to know how to call the value of the textbox since there is no field that the data is drawn from.

Replace the Fields!YourDateField.Value in my example with the expression that you are using. Or, even better, use what Visakh suggested, i.e., use the ReportItems!Textboxname.Value. The Textboxname, obviously, is the name of the textbox where you have the value displayed.