Show or not show

A

an

Hello!

I have a Form based in T_General with textboxes to:

Value
=Sum([Value])
=Count([Value])
=Avg([Value])

And 2 boxes (GreenBox and RedBox)

I would like to show green box or red box according to value is <Avg or >Avg
similary the:

If [Value] < [Avg] Then
RedBox.Visible = True
End If

Else

If[Value] > [Avg] Then
GreenBox.Visible = False
End If

End Sub

Thanks in advange.
an
 
R

Rick B

Why not just use conditional formatting to set the background color based on
the formula you mention below?
 
A

an

Thanks for yopur reply.

Is an idea, but I think "conditional formatting" isn't valid to boxes but
only to textboxes (?)

an

Rick B said:
Why not just use conditional formatting to set the background color based on
the formula you mention below?


--
Rick B



an said:
Hello!

I have a Form based in T_General with textboxes to:

Value
=Sum([Value])
=Count([Value])
=Avg([Value])

And 2 boxes (GreenBox and RedBox)

I would like to show green box or red box according to value is <Avg or
Avg
similary the:

If [Value] < [Avg] Then
RedBox.Visible = True
End If

Else

If[Value] > [Avg] Then
GreenBox.Visible = False
End If

End Sub

Thanks in advange.
an
Click to expand...
Click to expand...
 
R

Rick B

Can't you make a text box with a colored background?

--
Rick B



an said:
Thanks for yopur reply.

Is an idea, but I think "conditional formatting" isn't valid to boxes but
only to textboxes (?)

an

Rick B said:
Why not just use conditional formatting to set the background color based on
the formula you mention below?


--
Rick B



an said:
Hello!

I have a Form based in T_General with textboxes to:

Value
=Sum([Value])
=Count([Value])
=Avg([Value])

And 2 boxes (GreenBox and RedBox)

I would like to show green box or red box according to value is <Avg or
Avg
similary the:

If [Value] < [Avg] Then
RedBox.Visible = True
End If

Else

If[Value] > [Avg] Then
GreenBox.Visible = False
End If

End Sub

Thanks in advange.
an
Click to expand...
Click to expand...
Click to expand...
 
A

an

Ok, Rick B

Problem solved.
Thank you very much.

an

Rick B said:
Why not just use conditional formatting to set the background color based on
the formula you mention below?


--
Rick B



an said:
Hello!

I have a Form based in T_General with textboxes to:

Value
=Sum([Value])
=Count([Value])
=Avg([Value])

And 2 boxes (GreenBox and RedBox)

I would like to show green box or red box according to value is <Avg or
Avg
similary the:

If [Value] < [Avg] Then
RedBox.Visible = True
End If

Else

If[Value] > [Avg] Then
GreenBox.Visible = False
End If

End Sub

Thanks in advange.
an
Click to expand...
Click to expand...
 
A

an

Ok.
Already respondo to you.

Many, many thanks.
an

Rick B said:
Can't you make a text box with a colored background?

--
Rick B



an said:
Thanks for yopur reply.

Is an idea, but I think "conditional formatting" isn't valid to boxes but
only to textboxes (?)

an

Rick B said:
Why not just use conditional formatting to set the background color based on
the formula you mention below?


--
Rick B



Hello!

I have a Form based in T_General with textboxes to:

Value
=Sum([Value])
=Count([Value])
=Avg([Value])

And 2 boxes (GreenBox and RedBox)

I would like to show green box or red box according to value is <Avg or
Avg
similary the:

If [Value] < [Avg] Then
RedBox.Visible = True
End If

Else

If[Value] > [Avg] Then
GreenBox.Visible = False
End If

End Sub

Thanks in advange.
an
Click to expand...
Click to expand...
Click to expand...
 
Top