Formating Values in the report

[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.

 

[Marshall Barton]

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?

Use code in the Format event of the section containing the
text boxes you want to manipulate. The code will be
something like:

Select Case Me.Exceedance
Case 0
Me.txtName.FontWeight = 400
Me.txtResult.FontUnderline = True
Case 1
Me.txtName.FontWeight = 700
Me.txtResult.FontUnderline = False
Case Else
Me.txtName.FontWeight = 400
Me.txtResult.FontUnderline = False
End Select

 

[Alp Bekisoglu]

Hi Su Chen,

You can try:
Format | Conditional Formatting...

on the menu after you have selected the particular field on your report.

Alp