Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    36

    Unanswered: Changing row colors in datasheet

    Is there a way to conditionally change the background or foreground color of a datasheet row or column? For example if I list scheduled job information in a datasheet, for the jobs that are past due, I want to show them as red, for the jobs that need assignment within the hour I want them yellow, and all the rest should be green.

    I can't find a control or method that lets me change these properties at the row level. I know I can purchase third party apps like Spread.vbx from FarPoint to do this, but I don't want to spend any money.

    Any tips or techniques are greatly appreciated. Thanks

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    There was a discussion here about conditional formatting. Try to find the thread.

    Igor

  3. #3
    Join Date
    Jul 2002
    Posts
    36
    I don't think that was it. My problem is specifically with a datasheet view. I want to present a grid with different row colors, and not use a continuous single-row form.

  4. #4
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    AFAIK, can't be done in datasheet view. You have little control over formatting.

    Can be done in continuous forms. Think there are demos at
    http://www.mvps.org/access/forms/index.htm
    http://www.peterssoftware.com/
    http://www.lebans.com/conditionalformatting.htm

    Can I ask why you'd want to use a datasheet though? Anything you can do in a datasheet you can do in a continuous form.. and more!

    Cheers,
    Andrew
    Last edited by Bunce; 07-12-02 at 00:56.
    There have been many posts made throughout the world.
    This was one of them.

  5. #5
    Join Date
    Jul 2002
    Posts
    36
    Great links. Thanks.

    I just figured a datasheet would require less resourcess than a form, and less maintenance. Thanks again for the info.

    J

  6. #6
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Just found another link. Says it can format colours in datashet, however I haven't tried it:
    http://www.lebans.com/conditionalformatting.htm

    HTH,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

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