Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format cell to change colours

    Hello Gurus,

    Is it possible to change selected cells in a table to different colours? I can format the entire table to change
    the cells to red.

    Thanks Kindly

    Kerrie

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format cell to change colours

    Are you talking about tables or forms, and which version of Access are you using?
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format cell to change colours

    Hi Charlotte,

    I am talking about tables and the version is 2000.
    Can you do it in 97, as well?

    Thanks Kindly

    Kerrie

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format cell to change colours

    Why would you want to? It's a basic rule that users don't see tables. You display data for users in forms and reports and possibly in queries to keep users from accidentally damaging the data structures and generally doing stuff they shouldn't do. You can do things with displaying colors on forms, although I don't thing the conditional formatting in Access 2000 works properly, and I never use it.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format cell to change colours

    Thanks Charlotte I will have a look at the conditional formatting.

    Kerrie

Posting Permissions

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