Formating Values

[Su Chen]

Hello, all:

I have a table which including Columns: Name, Result,
criteria, Exceedance (0 or 1). In my report,I would like
to give different formats (underline, bold) to these
results which have the corresponding Exceedance (1), How
can I do this?

Your quick response is truly appreciated.

 

[Jim/Chris]

If you are using Acces 2000 or later try Condional
Formatting. It is located under Format/Conditional
Formating. You are allowd up to 3 conditions.

Jim

 

[su Chen]

but it can only work with number,what about if my data
contains sth like "<10"

Thanks

 

[Jim/Chris]

You could try something like this

Forms Conditional Formatting base on value
.. Do it on code:
Private Sub cboMyCombo_AfterUpdate()
Me.txtBox1.FontWeight = IIf(Me.cboMyCombo =
"value1", "Normal","Bold")
Me.txtBox2.FontWeight = IIf(Me.cboMyCombo =
"value2", "Normal","Bold")
Me.txtBox3.FontWeight = IIf(Me.cboMyCombo =
"value3", "Normal","Bold")
Me.txtBox4.FontWeight = IIf(Me.cboMyCombo =
"value4", "Normal","Bold")
Me.txtBox5.FontWeight = IIf(Me.cboMyCombo =
"value5", "Normal","Bold")
Me.txtBox6.FontWeight = IIf(Me.cboMyCombo =
"value6", "Normal","Bold")
End Sub

Private Sub Form_Current()
Call cboMyCombo_AfterUpdate
End Sub

Jim