Formating Values in the report

  • Thread starter Thread starter Su Chen
  • Start date Start date
S

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.
 
Su said:
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?
Click to expand...


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
 
Hi Su Chen,

You can try:
Format | Conditional Formatting...

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

Alp
 
Back
Top