Help with Time Blocking

This is the code that I am trying in the Detail Section. When I try to run the report, it errors out and says that "Method or data member not found" on the Me.Full_name.Top part of the code... any help

Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   Dim lngTopMargin As Long

   Dim lngOneMinute As Long 'size of one minute in twips
   Dim datSchedStart As Date
   datSchedStart = #8:00:00 AM#
   lngOneMinute = 12
   lngTopMargin = 1440 'timeline starts 1" down in section
   Me.MoveLayout = False
   Me.Full_name.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.TripTime) * lngOneMinute
   Me.Full_name.Height = 30 * lngOneMinute
   Me.Full_name.Left = Me.ReportColumn   'field in table
   Me.WVTNum.Left = Me.ReportColumn    'field in table
End Sub
 
It took me almost half an hour to do :eek: and I ended up not using code. See the attached db and run qryTimesBlock.
 

Attachments

Users who are viewing this thread

Back
Top Bottom