If you have a StartDate and an EndDate
stored in a table and want to display a MS-Project like timeline on an Access report,
you'll have to write code.
One way to accomplish this is to use a rectangle's dimension as a
baseline. The maximum width of the rectangle will denote the difference between the
maximum values of StartDate and EndDate respectively. Then if you have another
rectangle which will shrink/grow to match the dates, you can align the control using it's
Left property and give it a computed width using the baseline rectangle for
measurements.
Download TimeLines.Zip
sample database for an example.
|