CodeWidgets.com Online Source Code Library -ASP, ASP.NET, VB, VB.Net, Microsoft® Access, Javascript, VBScript, Website Design, Web Applications, Custom Programming Services Available.

 CodeWidgets.com ASP, ASP.NET, VB, VB.Net,
Microsoft® Access, Javascript, VBScript,
Website Design, Web Applications
Shopping Cart (0) Items $0.00      
 CodeWidgets.com
CodeWidgets.com

 

Website Stats to Date

Pages Viewed 4,401,732
Visitors 1,206,536
Widgets Viewed 3,009,755
Since January 1/2003
 
 
Active Users: 18
 

 
PayPal: Secure online payments!
 
Widget #CS0142

Change Conditional Formating in code (Microsoft® Access)

Change Conditional Formating in code (Microsoft® Access)

Send Link

Questions

Currency Conv.
  Widget Info  
Microsoft® Access 2000/XP
Set formatting based on the comparison of two different fields.

EXAMPLES
If ColumnOne is Greater thanColumnTwo then ColumnOne turns Red
If ColumnTwo is Equal to ColumnThree then ColumnTwo turns Black

Private Sub SetConditions()
On Error Resume Next

With Me.ValueOne.FormatConditions.Add(acFieldValue, acGreaterThan, "=[ValueTwo]")
.BackColor = RGB(255, 0, 0)
.FontBold = True
.ForeColor = RGB(255, 255, 255)
End With

With Me.ValueTwo.FormatConditions.Add(acFieldValue, acEqual, "=[ValueThree]")
.BackColor = RGB(0, 0, 0)
.FontBold = True
.ForeColor = RGB(255, 255, 255)
End With

End Sub
 Licensing
Format: Download
Online Purchase And Pickup
Licencing Terms: Developer Re-Use: Programming Experience Required
Project Development Use Only. Re-Distribution Permitted only as part of a compiled Application. This source code is provided to you "as is" without warranty.
CLICK HERE FOR TERMS OF USE
Copyright 2002-2006 Comrie Software Solutions
 Related Widgets

Alternate row colors on reports with Microsoft® Access
Alternate Subform/Datasheet row colors (Microsoft® Access)
Centralized Error Logging Function with Email
Corrupted Access Database Repair
Corrupted Access Database Repair with Data Extractor.
Create Outlook Calendar entries from Microsoft® Access.
Create Outlook Contact entries from Microsoft® Access.
Date Validation Function (Microsoft® Access,VB.6.0)

ShoppingCart Empty
Services Contact Info Legal Info
Designated trademarks and brand names are the property of their respective owners.

By accessing this website it is assumed that you agree to the TERMS OF USE.

Send questions or comments regarding this website to  Comrie Software Solutions.

Click here for a complete list of available Widgets.