[AccessD] Expiration Date

Arthur Fuller fuller.artful at gmail.com
Wed Oct 28 15:43:43 CDT 2009


I think that the central problem here is the use of a calculated column
rather than a real column. By using a real column, you could skip all the
DateDiff() stuff etc. and instead just calculate any given row's value in
the AfterUpdate event. After that, your color formatting becomes trivial.
Just examine the possible values and color the cells appropriately. This is
going to perform much more quickly than the run-time analysis of each
visible row. And given that what you are storing is a date, it's not going
to present much overhead.

Just my $0.02.

Arthur



More information about the AccessD mailing list