Efficient statement for making fields visible/invisible

[josephwc]

I have fields named after the month and year for the next two years (Jan2006 to Dec2007) with a field called "past" for values before Jan2006 and "future" for fields after Dec2007. The field names have a number value after them from (01-08) which relates to another particular field value in a field called txtfunc (01-08).

How do I create a statement without making an if then statement for all of the 208 different fields as shown in the example below?

If [EstimatedStartDate]<=#1/31/2006# and [EstimatedStartDate]+ [Duration]>= #1/1/2006# and isnotnull([txtfunc01.value] then
Jan200601.visible = true
else
Jan200601.visible = false
end if

 

[TheAceMan1]

How are ya josephwc . . .

What ever you do, you'll have to enumerate the forms [blue]Control Collection[/blue] . . .

See Ya! . . . . . .

 

[josephwc]

How would I go about that? I am not sure how to translate what I have into a Contolled Collection.