J
JS
I have a report that contains a subreport. The subreport displays
various interview times. We used 1/1/1980 12:00 AM as a special code,
so whenever the value of the time is that, I want the field on the
report to have a special formatting. I got that set up correctly on
the subreport using:
Expression Is: Year([Reports]![RequestListTimeSubform]![interview_time])="1980"
to see if the value has the year 1980. When I view just the subform,
this works.
When I view the report that contains the subform, it doesn't work, the
1980 times don't change formatting. I tried
Year([Reports]![RequestListTime]![RequestListTimeSubform]![interview_time])="1980"
or at least I thought I did, but that didn't work either.
I checked, and I am reasonably sure that RequestListTimeSubform is the
name of the control on the main form. I could be wrong; I didn't
initially create the reports, but I clicked on the subform and looked
at the name property.
Any ideas?
Thanks,
various interview times. We used 1/1/1980 12:00 AM as a special code,
so whenever the value of the time is that, I want the field on the
report to have a special formatting. I got that set up correctly on
the subreport using:
Expression Is: Year([Reports]![RequestListTimeSubform]![interview_time])="1980"
to see if the value has the year 1980. When I view just the subform,
this works.
When I view the report that contains the subform, it doesn't work, the
1980 times don't change formatting. I tried
Year([Reports]![RequestListTime]![RequestListTimeSubform]![interview_time])="1980"
or at least I thought I did, but that didn't work either.
I checked, and I am reasonably sure that RequestListTimeSubform is the
name of the control on the main form. I could be wrong; I didn't
initially create the reports, but I clicked on the subform and looked
at the name property.
Any ideas?
Thanks,