Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (reports) (2003)

    Is there a way to control the font size, weight and number of decimal places of controls on different rows of a report, so that different rows use different settings? I have been asked to produce a report which is sort of rotated through 90 degrees from the usual format that Access caters for. The report is for a retail company and will have one column for each of their stores. The rows will then (usually) come in threes:

    Performance this year
    Performance Last Year
    Percentage Change

    I have managed to rotate the data so that it fits this requirement, but I

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

    Re: Conditional Formatting (reports) (2003)

    You can use the Detail_Format event to format controls specifically for each record.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (reports) (2003)

    Of course! (sound of head being slapped)
    Thanks again.

    BTW, I didn't get an email to rell me that this reply had been posted. Have I changed a setting somewhere?

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

    Re: Conditional Formatting (reports) (2003)

    If the problem with no e-mail notifications persists, you can post a question in the Lounge Matters forum.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Warwick, Warwickshire, England
    Posts
    189
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (reports) (2003)

    I have had that problem too - it was down to an overly helpful ISP who thought that emails which are addressed to myself (which is what seems to happen with the messages from here) were trash and so held them in my trash folder.

  6. #6
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (reports) (2003)

    I've just received the three replies to the origanal post this morning.
    Has something happened at Woody's Lounge? I will contact my ISP anyway.

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

    Re: Conditional Formatting (reports) (2003)

    I'm not aware of something out of the ordinary in the Lounge, so I guess it's your ISP.

Posting Permissions

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