Background Format

[maysamab]

Dear All,


I Use Ms-Access 2003 Proffesional For My Porpuse.
I Want Select Colour Conditional Formating For textbox For Generating Report.
I Want Put Other Colours that they don't exist in Color Window(In Conditional Formatting Window)
For Example:
I Want Select Light Grey Colour For My Text Box But In Colour Pallet in Conditional Formating Window there is One Grey Colour.


How I Can Select Other Colour in Conditional Formatting Window For Text Boxes?

[thhui]

Use vba code to control the color instead.
Example code is as follows:

Private Sub Details_Format(Cancel As Integer, FormatCount As Integer)

    lngred = RGB(255, 0, 0)
    lngBlack = RGB(0, 0, 0)
    lngyellow = RGB(255, 255, 0)
    lngWhite = RGB(255, 255, 255)

    If Me.tbox1 = 1 Then
        Me.tbox1.BackColor = lngred
        Me.tbox1.ForeColor = lngyellow
    End If

End Sub

[maysamab]

Dear My Friend,
Thanks for Your Attention But How can i Use This code For My Report.
What is the "Me" in your Code?
Thanks

[thhui]

In VBA Module,
me = report in report
me = form in form

[maysamab]

Thanks
And How can I Link this code to My report or My form?

[thhui]

You'd better see some elementary access vba book first to grasp the basic knowledge so that you could use it in your report and form accordingly

[maysamab]

Dear My Friend
Private Sub Report_Activate()
lngred = RGB(255, 0, 0)
lngblack = RGB(0, 0, 0)
lngyellow = RGB(255, 255, 0)
lngwhite = RGB(255, 255, 255)

aa = TBOX1
If Me.TBOX1 = "AMIR" Then
Me.TBOX1.BackColor = lngred
Me.TBOX1.ForeColor = lngyellow
Else
Me.TBOX1.BackColor = lngblack
Me.TBOX1.ForeColor = lngwhite


End If
End Sub

I could write this code and link for my report successfully.
but i have many name like "AMIR" "MARY" "JOHN"
my code just compare first record with "AMIR" and if First Field is "AMIR" then All records in tbox1 in report is yellow but i want just amir is yellow!!
I read some vba access book but i can't solve this problem.

[thhui]

You should not use the Report_Activate() event in your case.

Instead you should simply use my previous stated event details_format() event.