Report Displaying Results

  • Thread starter Thread starter jetmech
  • Start date Start date
J

jetmech

My problem is trying to get the results of an expression to display on my
report. I am setting a deadline based on a specific start date [DCTB] and
highlighting if not completed on time. I would like the field to fill with
the expected completion date.

I have tried the following:
DateSerial(Year([DCTB]),Month([DCTB]),Day([DCTB])+90)<Date()

I have been able to get them to work based on color filling the Report I
just can't get the actual date to display. I don't even know if I can do it.
Any help will be greatly appreciated.
 
Why not just set the data source for the txtbox that holds due
Date to [DCTB] +90
Then in the OnFormat event of the section holding that control do
something like :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me!DCTBHolder.BackColor = IIf(([DCTBHolder] + 90 < Date), 65535,
16777215)
End Sub

Regards

Kevin
 
Back
Top