How do I change color attributes?

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

 

[Guest]

HI Jim

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

Select Format
Select Condidtional Formating
Save

 

[Pieter Wijnen]

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