CodeDocu.com

 

 

 

Highlight the control element and in ribbon menu-> format-> conditional formatting

Access: Conditional formatting Expression for adjacent fields

 

Comparison condition to a number

Dialog: Manager for Bedintern Formatting Rules

Open this with Edit rule

Access: Conditional formatting Expression for adjacent fields

Then comes an input field for entering the condition formula

 

Only format cells for which applies

 

Expression is: [Controlname] = 123

 

Access: Conditional formatting Expression for adjacent fields

Result: Conditional Formatting, Adjacent Field with Numeric Value

Now all cells are marked in color, which correspond to the condition in the adjacent field with value = 1

Access: Conditional formatting Expression for adjacent fields

 

Comparison condition to a text

 

If you want to compare to a letter string, then the expression must be in quotes

Expression is: [control] = "abc"

Access: Conditional formatting Expression for adjacent fields

 

Comparison result with text in adjacent cell

Access: Conditional formatting Expression for adjacent fields

 

 

 


Software Entwicklung Stuttgart NĂ¼rtingen
Suche Projekte C#, WPF, Windows App,ASP.Net, vb.Net, WinForms, SQL Server, Access, Excel