Results 1 to 5 of 5
  1. #1
    TCJ is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    3

    Applying Conditional Formatting on an access webform

    Can anyone tell me how to apply conditional formatting to a control field within a webform so that I can make the fields turn color based on a certain criteria? I understand that by default it is not designed to support this function, but I heard of other database developers making it work using macros.



    Thank you for your support.

    ~Tony

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Bing: Access web form conditional formatting

    Does this help http://answers.microsoft.com/en-us/o...a-5fd8eb5f5498
    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
    TCJ is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    3
    June7,

    Thank you for the information.

    I did in fact come across this article. Only problem is that it doesn't change the specific cell within that record. It changes the entire cell color. Another words, its like going into the forms property sheet and changing the back color of the cell, which applies to all.

    ~Tony

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Yes, changing properties of a control changes it for all records because there is only the one control. So this will not work for Datasheet or Continuous view.

    There are no other options for managing control properties.
    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
    TCJ is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    3
    Thanks June7. Not giving up hope just yet.

    V/R,

    Tony

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

Similar Threads

  1. Replies: 3
    Last Post: 11-04-2013, 07:40 PM
  2. Replies: 6
    Last Post: 05-26-2013, 09:10 PM
  3. Conditional Formatting in Access
    By Triland in forum Access
    Replies: 29
    Last Post: 01-18-2013, 01:00 PM
  4. Access Conditional formatting
    By mailboy in forum Access
    Replies: 1
    Last Post: 12-17-2011, 01:34 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