How can colorize a record of a tabular sub form??

jokelogpop

Registered User.
Local time
Yesterday, 22:31
Joined
Oct 16, 2004
Messages
22
Hi everybody!
I have a truoble! Anyone can help me??
I want to colorize a record of a tabular sub form when I has just updated it or find it from a table!
Thanks all! :)
 
Is the subform in datasheet view? If so, it is not possible.
 
Hi SJ McAbney!
I search in the assistance and find the result here!
FormatConditions, FormatCondition Object Example

The following example adds a conditional formatting to a text box, "Textbox1" and sets some properties of the newly added FormatCondition object.

With Forms("form1").Controls("Textbox1").FormatConditions _
.Add(acFieldValue, acGreaterThan, "=[Textbox2]")
.BackColor = RGB(255,255,255)
.FontBold = True
.ForeColor = RGB(255,0,0)
End WithThe following example sets format properties for an existing conditional format for the "Textbox1" control.

With forms("forms1").Controls("Textbox1").FormatConditions(1)
.BackColor = RGB(255,255,255)
.FontBold = True
.ForeColor = RGB(255,0,0)
End With

Did I find my solution??
 

Users who are viewing this thread

Back
Top Bottom