more than 3 conditional formats

[welshone]

hello all,
is it possible to have more than 3 conditional formats on a continuous form ?


thanks for any info.
W

 

[LittleSmudge]

Conditional formatting is fundimentally limited to 3 options per control ( Control; not Form, continuous or otherwise )


If you need more than three options then you need to do it in code - just like we always used to do before CF.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[welshone]

thanks for the response,
however, I don't know how to do this using code.
do you have any code samples or web links to tuitions ?

cheers.

 

[LittleSmudge]

In the Form's ON_Current event you put some code that looks at the values you are interested in a assigns an object's colour/font etc appropriately

Eg

If you have a text box control with a number in it you might do something like

Private Sub Form_Current()
txtValue.FontSize = 10
lblSpecialFlag.Visible=False
Select Case txtValue
Case < 0
    txtValue.BackColor = 123456
Case = 0
    txtValue.BackColor = 3456789
Case < 10
    txtValue.BackColor = 4354437
Case Else
    txtValue.BackColor = 4354437
    txtValue.FontSize = 12
    lblSpecialFlag.visible = True
End Select

'ope-that-'elps.
End Sub


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[RoyVidar]

Hi!

A search on these fora should give something (and is always encouraged). Here are two threads:
thread702-647405, thread702-661512

Else, I ususally say that conditional format has four formats. Three based on meeting different conditions, and the fourth when no condition is met.

Roy-Vidar

 

[bitbuster]

Hello,

The result of using the 'select case' in the 'on current' event is that the entire continuous form gets the formatting of the selected record. This does not replace the effect of conditional formatting.

Any other suggestions?

Regards,

Bit

 

[LittleSmudge]

Oh - you didn't mention that you were using continuous forms.

No the Select case only works on single record view because it relies on running in response to the OnCurrent event - which is itself a single record event.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.