Formatting a report

[jalby]

Hi,

I actually have a two part question. In creating a report is it possible to format the color of a field. The report is to track dues for a club. I would like to have it formatted so if the number is less than a certain number it would print in one color and if not then print in a differn't color.

The second part, can anyone give me guidance on how to place a picture as a background and watermark it.

Thanks

 

[Guest_imported]

Hi,

It is possible to change the back color and the fore color of fields in reports.

You should write code for this in the On Open event of the report.

Private Sub Report_Open(Cancel As Integer)

Me.Text0.BackColor = 1600436

Me.Text0.ForeColor = 170000

End Sub

You could substitute Text0 with the name of the field that you are using in your report.