Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting

    I learned another new trick this week by cruising the Forum.

    In a text box called: txtDayOfWeek on a REPORT, the data

    =Weekday([F02_UserDate])

    will display
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting

    See <post#=442,777>post 442,777</post#> and <post#=382,292>post 382,292</post#>. The databases attached to those posts demonstrate various ways of conditionally highlighting controls / records.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting

    Thanks for the quick, always appreciate, reply. I had looked at those examples before when I was Forum cruising, but they didn't seem to apply to my particular situation which is base on a report, not a continuous form. I've tried a number of combinations, which obviously didn't work, so I thought I'd try the Forum as I'm wont to do.

    Cheers, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Cheers,
    Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting

    For a report you can use the Detail_Format event procedure to color a control any way you want.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting

    Thanks Hans,

    I'll be having a go at this tonight and will get back to you if there's a problem.

    Cheers, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Cheers,
    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •