Results 1 to 5 of 5
  1. #1
    selvakumar.arc is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    49

    how to format Datasheet view cell

    Hi,

    Is there is any way to format a cell in Datasheet view in MS Access?

    I have a requirement to apply different background color for the cell whose value is different from its previous record cell value. Please find following sample scenario, based on that I have to update color for "Rules - ABC".

    Id -- version -- RulesVal
    1 -- 0 -- XYZ
    1 -- 1 -- ABC




    Regards,
    Selvakumar R

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,649
    Can't do this in table.

    This topic sounds familiar. Just answered this question not too long ago. Ahhah! Here it is: https://www.accessforums.net/forms/h...ime-35978.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    selvakumar.arc is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    49
    Yes, you are correct.
    There is any possibility to mark color for controls?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,649
    Issue already addressed in other thread. Same comments apply. Instead of starting a new thread, should have continued discussion in the original.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    selvakumar.arc is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    49
    Thanks for your reply. I am closing this thread and will continue in existing thread.
    https://www.accessforums.net/forms/ho...ime-35978.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  2. Replies: 16
    Last Post: 09-12-2012, 08:39 AM
  3. Datasheet view in tab only
    By cdzajp in forum Forms
    Replies: 1
    Last Post: 06-22-2011, 12:44 PM
  4. SearchBox and Datasheet View
    By gio25 in forum Forms
    Replies: 3
    Last Post: 03-23-2011, 06:07 PM
  5. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums