Conditinal Format

[Reggie]

Hi and TIA! I was wondering how to use condition formatting to place arrows
in an unbound control. So if I compare a value on my form with another
value, and the new value is >then the old value I would like to show an
arrow pointing up, if it's less an arrow down, etc. Is this possible.
Thanks for you time!
--
Reggie

----------

[fredg]

On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:

Hi and TIA! I was wondering how to use condition formatting to place arrows
in an unbound control. So if I compare a value on my form with another
value, and the new value is >then the old value I would like to show an
arrow pointing up, if it's less an arrow down, etc. Is this possible.
Thanks for you time!

Not using Conditional formatting.

In Single Form View only:

Set the unbound control's FontStyle to Wingdings.

Then code the Form's Current event...
If ANumberControl > SomeValue Then
SomeControl = Chr(241)
ElseIf ANumberControl < SomeValue Then
SomeControl = Chr(242)
Else
ANumberControl = ""
End If

If the values are user input in the form, place the same code in the
that control's AfterUpdate event as well.

The above is not suitable for continuous form view.

Note: Other arrow styles are available. Check the Character Map
(located in Start + All Programs + Accessories) for additional styles.
Just substitute the chr() value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Reggie]

Fred, Thanks! I am using a single form view so this will work great. For
some reason I always forget about those WingDingyThingy's.

--
Reggie

----------
"fredg" <fg******@example.invalid> wrote in message
news:1u*****************************@40tude.net...

On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:

Hi and TIA! I was wondering how to use condition formatting to place arrows in an unbound control. So if I compare a value on my form with another
value, and the new value is >then the old value I would like to show an
arrow pointing up, if it's less an arrow down, etc. Is this possible.
Thanks for you time!

Not using Conditional formatting.

In Single Form View only:

Set the unbound control's FontStyle to Wingdings.

Then code the Form's Current event...
If ANumberControl > SomeValue Then
SomeControl = Chr(241)
ElseIf ANumberControl < SomeValue Then
SomeControl = Chr(242)
Else
ANumberControl = ""
End If

If the values are user input in the form, place the same code in the
that control's AfterUpdate event as well.

The above is not suitable for continuous form view.

Note: Other arrow styles are available. Check the Character Map
(located in Start + All Programs + Accessories) for additional styles.
Just substitute the chr() value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Reggie]

Fred, Another side question. I selected the character map and selected
wingdings from the drop-down box. I don't see anything in there with 241 0r
242 like you explained. I did use it in my code, and it did display arrows,
but was wondering how/where you got the values above from. I do see the
Character code at the bottom, but all I get are hex numbers like 0xE8 etc.
Any advice would be appreciated. Thanks again.

--
Reggie

----------
"fredg" <fg******@example.invalid> wrote in message
news:1u*****************************@40tude.net...

On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:

Hi and TIA! I was wondering how to use condition formatting to place arrows in an unbound control. So if I compare a value on my form with another
value, and the new value is >then the old value I would like to show an
arrow pointing up, if it's less an arrow down, etc. Is this possible.
Thanks for you time!

Not using Conditional formatting.

In Single Form View only:

Set the unbound control's FontStyle to Wingdings.

Then code the Form's Current event...
If ANumberControl > SomeValue Then
SomeControl = Chr(241)
ElseIf ANumberControl < SomeValue Then
SomeControl = Chr(242)
Else
ANumberControl = ""
End If

If the values are user input in the form, place the same code in the
that control's AfterUpdate event as well.

The above is not suitable for continuous form view.

Note: Other arrow styles are available. Check the Character Map
(located in Start + All Programs + Accessories) for additional styles.
Just substitute the chr() value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[fredg]

On Thu, 29 Jul 2004 22:13:49 -0700, Reggie wrote:

Fred, Another side question. I selected the character map and selected
wingdings from the drop-down box. I don't see anything in there with 241 0r
242 like you explained. I did use it in my code, and it did display arrows,
but was wondering how/where you got the values above from. I do see the
Character code at the bottom, but all I get are hex numbers like 0xE8 etc.
Any advice would be appreciated. Thanks again.

Here is my "scientific" method to get the ascii value of a character.
From the Character Map, select the character and copy it to the
clipboard.

Open any database and press ctrl + G (opening the debug window).
Type
? asc("PasteHere") where PasteHere means paste the clipboard inside
the quotes)

Press Enter and you now have the value.
Try chr(225) for a different Up arrow.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Reggie]

Fred, awesome. Tricks of the trade!!!! Thanks much!!

--
Reggie

----------
"fredg" <fg******@example.invalid> wrote in message
news:q5****************************@40tude.net...

On Thu, 29 Jul 2004 22:13:49 -0700, Reggie wrote:

Fred, Another side question. I selected the character map and selected
wingdings from the drop-down box. I don't see anything in there with 241 0r 242 like you explained. I did use it in my code, and it did display arrows, but was wondering how/where you got the values above from. I do see the
Character code at the bottom, but all I get are hex numbers like 0xE8 etc. Any advice would be appreciated. Thanks again.

Here is my "scientific" method to get the ascii value of a character.
From the Character Map, select the character and copy it to the
clipboard.

Open any database and press ctrl + G (opening the debug window).
Type
? asc("PasteHere") where PasteHere means paste the clipboard inside
the quotes)

Press Enter and you now have the value.
Try chr(225) for a different Up arrow.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.