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]

Re: Conditinal Format

On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:
[color=blue]
> 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![/color]


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]

Re: Conditinal Format

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" <fgutkind@examp le.invalid> wrote in message
news:1uohdfdc3r 7r3.1st5xs4inlm yi.dlg@40tude.n et...[color=blue]
> On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:
>[color=green]
> > Hi and TIA! I was wondering how to use condition formatting to place[/color][/color]
arrows[color=blue][color=green]
> > 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![/color]
>
>
> 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.[/color]

[Reggie]

Re: Conditinal Format

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" <fgutkind@examp le.invalid> wrote in message
news:1uohdfdc3r 7r3.1st5xs4inlm yi.dlg@40tude.n et...[color=blue]
> On Wed, 28 Jul 2004 13:55:40 -0700, Reggie wrote:
>[color=green]
> > Hi and TIA! I was wondering how to use condition formatting to place[/color][/color]
arrows[color=blue][color=green]
> > 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![/color]
>
>
> 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.[/color]

[fredg]

Re: Conditinal Format

On Thu, 29 Jul 2004 22:13:49 -0700, Reggie wrote:
[color=blue]
> 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.[/color]

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]

Re: Conditinal Format

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

--
Reggie

----------
"fredg" <fgutkind@examp le.invalid> wrote in message
news:q5iy4ipd4x qq.zgzsijds7xcj $.dlg@40tude.ne t...[color=blue]
> On Thu, 29 Jul 2004 22:13:49 -0700, Reggie wrote:
>[color=green]
> > 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[/color][/color]
241 0r[color=blue][color=green]
> > 242 like you explained. I did use it in my code, and it did display[/color][/color]
arrows,[color=blue][color=green]
> > 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[/color][/color]
etc.[color=blue][color=green]
> > Any advice would be appreciated. Thanks again.[/color]
>
> 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.[/color]