Text box that has either No arrow or Up Arrow or Down Arrow in it.

[Guest]

I would like to have an arrow entered into a text box, based on my Result
Field. If the number is above a certain number or below a certain number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Duane Hookom]

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.

 

[Guest]

I have one field named Results, it has 3 conditional formatings. 1st turns
the BackGround red if expression is meet. 2nd turns BG yellow if meet. 3rd
turns BG green if expression is meet. Otherwise the BG stays white. These
numbers are based on the MEAN and STD DEV. So they can be higher or lower
than the mean.
I would like to have field to place an arrow in next to the result, showing
higher or lower.
This is one of my Expressions [Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

 

[Duane Hookom]

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st turns
the BackGround red if expression is meet. 2nd turns BG yellow if meet. 3rd
turns BG green if expression is meet. Otherwise the BG stays white. These
numbers are based on the MEAN and STD DEV. So they can be higher or lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.

 

[Guest]

Yes I did what you sugested, it works. But I need it to put in a arrow up if
it is above the mean or and arrow down if it is below mean. How can I do
this? What would the code be to enter it in conditional formating?
Diane

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st turns
the BackGround red if expression is meet. 2nd turns BG yellow if meet. 3rd
turns BG green if expression is meet. Otherwise the BG stays white. These
numbers are based on the MEAN and STD DEV. So they can be higher or lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on my
Result
Field. If the number is above a certain number or below a certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Duane Hookom]

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a arrow up
if
it is above the mean or and arrow down if it is below mean. How can I do
this? What would the code be to enter it in conditional formating?
Diane

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays white.
These
numbers are based on the MEAN and STD DEV. So they can be higher or
lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on my
Result
Field. If the number is above a certain number or below a certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Guest]

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the Result
number is above the mean number or a arrow DOWN (picture) if the result is
below mean.
Diane

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a arrow up
if
it is above the mean or and arrow down if it is below mean. How can I do
this? What would the code be to enter it in conditional formating?
Diane

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays white.
These
numbers are based on the MEAN and STD DEV. So they can be higher or
lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on my
Result
Field. If the number is above a certain number or below a certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Duane Hookom]

Again, "If you did this, what are you seeing in the text box if not up and
down arrows?"

What is your Control Source property?

--
Duane Hookom
MS Access MVP

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the Result
number is above the mean number or a arrow DOWN (picture) if the result is
below mean.
Diane

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did
this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a arrow
up
if
it is above the mean or and arrow down if it is below mean. How can I
do
this? What would the code be to enter it in conditional formating?
Diane


:

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if
meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays white.
These
numbers are based on the MEAN and STD DEV. So they can be higher or
lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on my
Result
Field. If the number is above a certain number or below a certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Guest]

I get up arrows from the mean number and up. I get down arrows below the mean
number. I do not want and arrow diplayed when the number is on the mean. If I
can't do it any other way this will work. Do you have any ideas?
I thank you for your patience with me.
Diane Thank You.

Again, "If you did this, what are you seeing in the text box if not up and
down arrows?"

What is your Control Source property?

--
Duane Hookom
MS Access MVP

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the Result
number is above the mean number or a arrow DOWN (picture) if the result is
below mean.
Diane

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did
this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a arrow
up
if
it is above the mean or and arrow down if it is below mean. How can I
do
this? What would the code be to enter it in conditional formating?
Diane


:

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings. 1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if
meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays white.
These
numbers are based on the MEAN and STD DEV. So they can be higher or
lower
than the mean.
I would like to have field to place an arrow in next to the result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on my
Result
Field. If the number is above a certain number or below a certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Duane Hookom]

So this all works except where the values are equal? Then, I assume you
don't want to display anything when the value is 0. This can be done by
setting your Format property to:
Format: \á;\â;"";""

--
Duane Hookom
MS Access MVP

I get up arrows from the mean number and up. I get down arrows below the
mean
number. I do not want and arrow diplayed when the number is on the mean.
If I
can't do it any other way this will work. Do you have any ideas?
I thank you for your patience with me.
Diane Thank You.

Again, "If you did this, what are you seeing in the text box if not up
and
down arrows?"

What is your Control Source property?

--
Duane Hookom
MS Access MVP

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the Result
number is above the mean number or a arrow DOWN (picture) if the result
is
below mean.
Diane

:

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did
this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a
arrow
up
if
it is above the mean or and arrow down if it is below mean. How can
I
do
this? What would the code be to enter it in conditional formating?
Diane


:

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings.
1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if
meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays
white.
These
numbers are based on the MEAN and STD DEV. So they can be higher
or
lower
than the mean.
I would like to have field to place an arrow in next to the
result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on
my
Result
Field. If the number is above a certain number or below a
certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Guest]

\á;"â This works, shows arrows going up with increasing values and
arrows down with decreasing values.
When I put in your code (\á;\â;"";"") I only get arrows decreaseing in value
below mean. No other arrows.
When I put in a backslash, it gives me this " sometimes.
I must be doing somthing wrong.
Diane

So this all works except where the values are equal? Then, I assume you
don't want to display anything when the value is 0. This can be done by
setting your Format property to:
Format: \á;\â;"";""

--
Duane Hookom
MS Access MVP

I get up arrows from the mean number and up. I get down arrows below the
mean
number. I do not want and arrow diplayed when the number is on the mean.
If I
can't do it any other way this will work. Do you have any ideas?
I thank you for your patience with me.
Diane Thank You.

Again, "If you did this, what are you seeing in the text box if not up
and
down arrows?"

What is your Control Source property?

--
Duane Hookom
MS Access MVP

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the Result
number is above the mean number or a arrow DOWN (picture) if the result
is
below mean.
Diane

:

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you did
this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a
arrow
up
if
it is above the mean or and arrow down if it is below mean. How can
I
do
this? What would the code be to enter it in conditional formating?
Diane


:

Do what I suggested and set the control source to something like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional formatings.
1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow if
meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays
white.
These
numbers are based on the MEAN and STD DEV. So they can be higher
or
lower
than the mean.
I would like to have field to place an arrow in next to the
result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You. Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based on
my
Result
Field. If the number is above a certain number or below a
certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane

 

[Duane Hookom]

Do you understand why any of this is happening? Do you understand why
Wingdings? Do you understand the four parts of a Format property for numeric
values? If not, search Help on numeric format.

--
Duane Hookom
MS Access MVP

\á;"â This works, shows arrows going up with increasing values and
arrows down with decreasing values.
When I put in your code (\á;\â;"";"") I only get arrows decreaseing in
value
below mean. No other arrows.
When I put in a backslash, it gives me this " sometimes.
I must be doing somthing wrong.
Diane

So this all works except where the values are equal? Then, I assume you
don't want to display anything when the value is 0. This can be done by
setting your Format property to:
Format: \á;\â;"";""

--
Duane Hookom
MS Access MVP

I get up arrows from the mean number and up. I get down arrows below the
mean
number. I do not want and arrow diplayed when the number is on the
mean.
If I
can't do it any other way this will work. Do you have any ideas?
I thank you for your patience with me.
Diane Thank You.

:

Again, "If you did this, what are you seeing in the text box if not up
and
down arrows?"

What is your Control Source property?

--
Duane Hookom
MS Access MVP

I see the wingding fonts and yes I did what you said about the format
property. But what I want to see is a arrow UP (picture) if the
Result
number is above the mean number or a arrow DOWN (picture) if the
result
is
below mean.
Diane

:

What displays in the text box I suggested? Did you set the font to
Wingdings? Did you set the Format property as I suggested? If you
did
this,
what are you seeing in the text box if not up and down arrows?


--
Duane Hookom
MS Access MVP

Yes I did what you sugested, it works. But I need it to put in a
arrow
up
if
it is above the mean or and arrow down if it is below mean. How
can
I
do
this? What would the code be to enter it in conditional
formating?
Diane


:

Do what I suggested and set the control source to something
like:
=[Results]-([RangMean]-([RangStdDev]*3))-0.002


--
Duane Hookom
MS Access MVP

I have one field named Results, it has 3 conditional
formatings.
1st
turns
the BackGround red if expression is meet. 2nd turns BG yellow
if
meet.
3rd
turns BG green if expression is meet. Otherwise the BG stays
white.
These
numbers are based on the MEAN and STD DEV. So they can be
higher
or
lower
than the mean.
I would like to have field to place an arrow in next to the
result,
showing
higher or lower.
This is one of my Expressions
[Results]<([RangMean]-([RangStdDev]*3))-0.002
Or [Results]>([RangMean]+([RangStdDev]*3))

Have I totaly confused you? Can you help me? Thank You.
Diane

:

If you have a form with 3 text boxes:
txtOne with one number
txtTwo with another number
txtThree where you want to display an up or down arrow
Name: txtThree
Control Source: =Val(txtOne-txtTwo)
Font: Wingdings
Format: \á;\â

If your question is different, please provide greater
details.
--
Duane Hookom
MS Access MVP

I would like to have an arrow entered into a text box, based
on
my
Result
Field. If the number is above a certain number or below a
certain
number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?

Diane