<div>
By Like, do you mean containing the word Extended?<br />
<br />
<br />
- Right-click the DiscPL1 control in design view and select &quot;Conditional formatting...&quot;<br />
<br />
- Select &quot;Expression IS &quot;&nbsp;from the drop down list<br />
<br />
- Enter the following expression in the textbox provided:<br />
<br />
&nbsp; &nbsp; &nbsp; 
<pre><code id="code-20-39694406-1">  Instr(1, [Forms]![frmMainForm]![[parttype], &quot;Extended&quot;) &gt; 0</code></pre>
<br />
- Then select the color you want to see when that condition is met.
</div>


By Like, do you mean containing the word Extended?


- Right-click the DiscPL1 control in design view and select "Conditional formatting..."

- Select "Expression IS " from the drop down list

- Enter the following expression in the textbox provided:

     

  Instr(1, [Forms]![frmMainForm]![[parttype], "Extended") > 0


- Then select the color you want to see when that condition is met.

<div>
<div class="content wysiwyg-content">
I have a mainform with an Object called [parttype’ and a subform form with an object called [DiscPL1] and need to do some conditional formatting on [DiscPL1] if [Partype] file’s value is &nbsp;like “Extended”.<br />
I am using the “conditional formatting” function in MS Access 2007. &nbsp;Below is what I have that isn’t working. &nbsp;<br />
IIF ([Forms]![frmMainForm]![[p<wbr />arttype] Like &quot;Extended&quot;,[DiscPL1].BackC<wbr />olor &nbsp;= #ED1C24)<br />
<br />
Could I please get help in getting the [DiscPL1] object to change the back color from blue to red if the condition is meet. &nbsp;thanks
</div>
</div>


I have a mainform with an Object called [parttype’ and a subform form with an object called [DiscPL1] and need to do some conditional formatting on [DiscPL1] if [Partype] file’s value is  like “Extended”.
I am using the “conditional formatting” function in MS Access 2007.  Below is what I have that isn’t working.  
IIF ([Forms]![frmMainForm]![[parttype] Like "Extended",[DiscPL1].BackColor  = #ED1C24)

Could I please get help in getting the [DiscPL1] object to change the back color from blue to red if the condition is meet.  thanks

Conditional Formatting

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.