Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23

    conditional formatting

    Hi!
    I needs conditional formatting on the form , ending with "s or m"(for example KKKm or LLLs).
    If it is possible?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use an expression rule:

    [fieldname] LIKE "*m" Or [fieldname] LIKE "*s"
    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
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No, need to select Expression Is in the dropdown.
    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
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    Can u screen me , where it is?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    It's the dropbox that says "Field Value Is". Just change to "Expression Is".

    Review https://www.tutorialspoint.com/ms_ac...formatting.htm
    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.

  7. #7
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    ok, thx


    I change to expresion and copy your formule , but it dont working , i dont why, can u look if in formule is ok?
    http://prntscr.com/rsxpeq

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Follow my example. It works for me.

    Need the fieldname just as I showed in my example. Of course, use your field name.

    [yourfieldname] LIKE "*m" Or [yourfieldname] LIKE "*s"
    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.

  9. #9
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You can also try =Right([Kolumna6],1) IN ("m","s")

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  10. #10
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    Quote Originally Posted by Gicu View Post
    You can also try =Right([Kolumna6],1) IN ("m","s")

    Cheers,

    yes i need this for all column but i have error when i copy Your code:
    http://prntscr.com/rt1ndu

    I dont know why?

  11. #11
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    Write :
    condition 1
    Code:
    Right([Kolumna6];1) = "m"
    condition 2
    Code:
    Right([Kolumna6];1) = "s"

  12. #12
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    It is working now , thx

  13. #13
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    Quote Originally Posted by CarlettoFed View Post
    Write :
    condition 1
    Code:
    Right([Kolumna6];1) = "m"
    condition 2
    Code:
    Right([Kolumna6];1) = "s"

    I have such a question, you can mark several or more columns at once for formatting or do I have to fill out the conditions separately?

  14. #14
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can select multiple textboxes and comboboxes and build same rule for all simultaneously. However, if each needs to reference themselves, will have to edit each control's rule individually.
    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.

  15. #15
    mannyy12 is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    23
    when I select several columns in the form, the choice of conditional formatting begins to be unobtainable as on the screen:
    http://prntscr.com/rt7ia7
    I dont know why

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conditional formatting
    By TGHMan in forum Forms
    Replies: 1
    Last Post: 06-16-2018, 12:46 AM
  2. Replies: 2
    Last Post: 11-12-2015, 10:46 AM
  3. Replies: 6
    Last Post: 05-26-2013, 09:10 PM
  4. Conditional Formatting
    By schwabe in forum Reports
    Replies: 2
    Last Post: 02-01-2012, 10:28 AM
  5. Conditional Formatting
    By cevatyildiz in forum Forms
    Replies: 8
    Last Post: 04-30-2010, 12:01 PM

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