color coding by value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm having trouble figuring this one out...
basically i have a timesheet for my work hours... set up as a form, multiple
items. (date worked, time in, time out, total hours)
i have a text box to the left of work date that "calculates" and displays
the correct day (Mon, Tue) for the date. Here's the prob: my pay period
runs from wed-tue. what i want is for the day for each pay period to be
shown in a different color (alternating is fine) so wed-tue would be red,
then the next wed-tue blue, then back again. i can't quite figure out the
coding for this.... any help is much appreciated!! thanx in advance :)
 
aft3rgl0w said:
i have a timesheet for my work hours... set up as a form, multiple
items. (date worked, time in, time out, total hours)
i have a text box to the left of work date that "calculates" and displays
the correct day (Mon, Tue) for the date. Here's the prob: my pay period
runs from wed-tue. what i want is for the day for each pay period to be
shown in a different color (alternating is fine) so wed-tue would be red,
then the next wed-tue blue, then back again.
Click to expand...

It sounds like you have a record in a table for each week
and each record has fields for Wed date, timein and timeout,
Thur date, timein and timeout, Fri . . .. Then you have a
form in continuous (or datasheet) view that displays a
bunch(?) of these records.

If that's what you are working with, set the text box's
(weekday?) BackColor to red. Then use Conditional
Formatting on the text box to specify blue for the even
numbered weeks. The CF expression Is: option would be like:
DatePart("ww", [datefield], 4) Mod 2 = 0
 
Back
Top