Access Report Formating

D

David C. Holley

I'm trying to setup a report in Access that display/hides a field if a
value is present and then moves the text immediately below the field up
1 line to fill the space.

Design

Calendar Date
Time Scheduled
Time Departure

Scenario 1: Time Sched Exists, Time Depar Exist
2/14/2005
7:45 PM (Scheduled)
8:05 PM (Actual)

Scenario 2: Time Sched Does not exist, Time Departure Exists
2/14/2005
8:05 PM (Actual)

I tried code in the onFormat & onPrint event to programically change the
values of the two fields (Time Scheduled & Time Departure) to acheive
the effect, however Access threw an error saying that the value for the
object could not be set ([Reports]![frmInvoice]![dspTimeScheduled] =
exprTimeActual).
I've tried setting the CanShrink value for the Time Scheduled field to
true, but that didn't work. Even though I've done something similar with
the address fields that appear in the REPORT HEADER where it works.

Suggestions?

David H
 
Top