more colors on conditional format

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

 

[Arvin Meyer [MVP]]

Microsoft Senior Technical Writer, Frank Rice may have just what you need:

http://msdn.microsoft.com/en-us/library/aa139965(office.10).aspx

and a Knowledge Base article may also help:

http://support.microsoft.com/kb/304104

 

[Gina Whipp]

Deb,

You're going to have to write your own conditional formatting... We can
help if you give some field names to work with and what you want to happen
and when you want it to happen.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

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

 

[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

 

[Gina Whipp]

Deb,

Missed that continous form... try this

http://office.microsoft.com/en-us/access/HA010448511033.aspx

I had forgotten about that issue of "all the fields in the column change".
I have not tested the above.



--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

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

 

[Gina Whipp]

Deb,

Here's something from Allen Browne...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

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

 

[Arvin Meyer [MVP]]

Did you try Frank Rice's method? It does work for continuous forms.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com