Show or not show

[Guest]

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

 

[Rick B]

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

 

[Guest]

Thanks for yopur reply.

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

an

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

 

[Rick B]

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

--
Rick B

Thanks for yopur reply.

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

an

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

 

[Guest]

Ok, Rick B

Problem solved.
Thank you very much.

an

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

 

[Guest]

Ok.
Already respondo to you.

Many, many thanks.
an

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

--
Rick B

Thanks for yopur reply.

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

an

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