Results 1 to 8 of 8
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    change background color on selected item in list form


    I have a simple list form with 4 fields: invoice no., invoice date, customer & invoice amount.
    When I click any fields in the list, how to change its background color to red?
    thanks.

  2. #2
    Sam is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2022
    Posts
    50
    I'm a beginner too but in Design or Layout View, select the field and in Format you will find the option to Fill.

  3. #3
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149
    sorry. i don't express my question well.
    i mean in running the list form, i click a field "Invoice No." in that list form, its background changes to red.
    Then if i click another field "Customer", the "Customer" background changes to red, the "Invoice No." changes back to white.
    thanks

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Use Conditional Formatting. https://support.microsoft.com/en-us/...%20See%20More.
    Use "Field Has Focus" rule.

    However, it is available only for textboxes and comboboxes.
    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
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Quote Originally Posted by orange View Post
    OMG, I hope twgonder does not see that, he will have a heart attack.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    While interesting, I don't think that video addresses the OP's question. By "list form" I think they mean a datasheet or continuous form. And the "fields" are controls on form.
    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.

  8. #8
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149
    THANKS June7.
    it solves.

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

Similar Threads

  1. Change Color Background frm list
    By Giulio Benvenuti in forum Access
    Replies: 2
    Last Post: 03-22-2021, 02:56 AM
  2. Replies: 4
    Last Post: 08-16-2019, 03:11 PM
  3. Replies: 8
    Last Post: 11-28-2015, 12:00 PM
  4. Replies: 4
    Last Post: 08-29-2015, 07:38 AM
  5. Change Font Color of Selected List Box Item
    By buckwheat in forum Access
    Replies: 2
    Last Post: 06-03-2013, 03:46 PM

Tags for this Thread

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