more colors on conditional format

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have a continuous form so I must use the built in conditional formatting
for a text box. However I need colors that are different than what the
choices are limited to.

I need the colors 16513785 and 15128784 and 13612455
Any ideas on how to do this?
 
The form is a "continuous form" and VBA only pick ups the first option and
makes all results that option. It makes everyting the first color.

Select Case Me!txtPhase
Case "ORDER ENTRY"
Me!txtPhase.BackColor = 16513685
Case "ORDER EXECUTION"
Me!txtPhase.BackColor = 15128784
Case "PROJECT CLOSEOUT"
Me!txtPhase.BackColor = 13612455
Case Else
Me!txtPhase.BackColor = 0
End Select

Any suggestions?
 
The form is a "continuous form" and VBA only pick ups the first option and
makes all results that option. It makes everyting the first color.

Select Case Me!txtPhase
Case "ORDER ENTRY"
Me!txtPhase.BackColor = 16513685
Case "ORDER EXECUTION"
Me!txtPhase.BackColor = 15128784
Case "PROJECT CLOSEOUT"
Me!txtPhase.BackColor = 13612455
Case Else
Me!txtPhase.BackColor = 0
End Select
 
Hey Gina!!

Conditional formatting that is in Tools > Conditional formatting will work
for continuous forms. but It does not have the colors that i need. It
contanis only a basic palet of colors. I must use the colors in my previous
post.

Any suggestions?
 
You need somthing link this:

Me!txtPhase.FormatConditions.Delete 'removes anything
inadvertantly saved
Me!txtPhase.BackColor = 0 'sets the default color
Me!txtPhase.FormatConditions.Add acExpression, acEqual, "txtPhase =
'ORDER ENTRY'"
Me!txtPhase.FormatConditions(0).BackColor = 16513685
Me!txtPhase.FormatConditions.Add acExpression, acEqual, "txtPhase =
ORDER EXECUTION"
Me!txtPhase.FormatConditions(1).BackColor = 15128784
Me!txtPhase.FormatConditions.Add acExpression, acEqual, "txtPhase =
'PROJECT CLOSEOUT"
Me!txtPhase.FormatConditions(2).BackColor = 13612455

I generally put all the conditional formating stuff in a sub and call
it from the forms Load event.

Good luck.
 
Back
Top