Hi!
I needs conditional formatting on the form , ending with "s or m"(for example KKKm or LLLs).
If it is possible?
Hi!
I needs conditional formatting on the form , ending with "s or m"(for example KKKm or LLLs).
If it is possible?
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.
like this?
http://prntscr.com/rswahu
i have this error:
http://prntscr.com/rswav6
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.
Can u screen me , where it is?
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.
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
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.
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?
Write :
condition 1
condition 2Code:Right([Kolumna6];1) = "m"
Code:Right([Kolumna6];1) = "s"
It is working now , thx
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.
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