Conditional format

[Niklas Östergren]

Hi!

Is it possible to have conditional format in a continious form?

I´d like to format a membership fee bold and red if the value <> from the
value correct value for that type of membership (we have 4 different types
of memberships.

This is what I have so far but I havn´t got it to work the way I want. If I
put the code in the form´s Open_Event it format ALL value red which isn´t
true.

It´s late here so I´ll be back tomorrow morning!

TIA!
// Niklas


'===========================================
With Me.txtEntryFeePayed
If .Value <> DLookup("MemberShipPrice",
"tblLookUpMemberShipType", "MemberShipTypeID = " & Me.cboMemberShipType)
Then
.ForeColor = 255
.FontBold = True
.FontSize = 8
.Height = 300
Else
.ForeColor = -2147483640
.FontBold = False
.FontSize = 8
.Height = 300
End If
End With
End With
'==========================================

 

[Niklas Östergren]

Sorry I posted this in wrong news group. I have posted it in news gropu
formscoding instead so pleas forget about this msg.

// Niklas

 

[Douglas J. Steele]

What version of Access are you using, Niklas?

Stephen Lebans has an example for Access 2000 and higher at
http://www.lebans.com/conditionalformatting.htm

If you're using Access 97 or earlier, there is no conditional formatting,
but there are a couple of kludges available at
http://www.mvps.org/access/forms/frm0024.htm at "The Access Web"

 

[Niklas Östergren]

Hi Doglas!

I´m getting help from Marshall Barton at the moment and I have made it half
the way. So I´ll take a look at Stephen Lebans conditional formatting since
I´m running A2002.

Thank´s for the tip and for taking time.

I´ll keep on writing about this matter in newsgroup formscoding since ther´s
where I first shoul have posted this Q. So if you have any more help to give
me in this matter please replye at my post in
microsoft.access.public.formscoding 2004-11-15 23:06 (GMT - 1)

// Niklas