label appear

[nahum abramovich]

HI

thanks for your help!

i need guidance for making text box or label appear (on form) when 4 condition (from query) is met - This is just for showing a sign that pops up (doesn't have to be text inside).

i tried to do this with conditional Formatting but my knowledge of Access is not so good...


i tried something like this.....(inside expression builder)....

[B]iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )



i tried to do this also in label/text box control source .....


And that's probably not the way to do it ...

Would appreciate help

[ranman256]

Make a routine for the action,showLbl()

sub ShowLbl()
Label.visible= txtBox <>"Danny" And txtBox2<> "Triangular" And txtBox3= "Red" And txtBox4 > 1
end sub

then call it when things change,
OnCurrent event,
textbox afterupdate,

anthing that could alter the condition.

[accesstos]

An other way without VBA:

Put the condition in a new field (say [Msg]) of the query and then bind the textbox on it.

Field expression:

Msg: iif([q]![a]="Danny" And [q]![b]="Triangular" And [q]![c]="Red" And [q]![d]>"1","ATTENTION","")

PS. Note that the [q]![d]>"1" is not the same with [q]![d]>1