How do I change color attributes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for help with a color setting on a report.

I'm designing a report in which the background & foreground colors for a
single text box need to change based on a query generated value.

The query contains fields that specify the background & foreground attribute
colors that I assign for these text boxes (for example, green = 44544).

How do I use the query result (green = 44544) to change the foreground or
background color attributes dynamically?

My database is running in Access 2000.

Thanks in advance for any help.
 
HI Jim

You can use use Conditional Formating but this will only work for a few
stipulations.

Select Format
Select Condidtional Formating
Save
 
Or Code in the Details section

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.MyTextBox.ForeColor = Me.MyColorField.Value
End Sub

HtH

Pieter
 
Back
Top