more colors on conditional format

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?
 
D

deb

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?
 
D

deb

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
 
D

deb

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?
 
T

Tom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top