List box - Detect changed value

  • Thread starter Thread starter John
  • Start date Start date
J

John

Access 2010

Looking for any pointers. I have a 2 column list box that refreshes at
set intervals. First column is text. Second column is amount, which
can fluctuate at each interval. I'm trying to highlight the amount if
it changes. Sort of like what a stock ticker would do.

LISTBOX
(First refresh)
ItemA 1000
ItemB 2000
ItemC 3000

(Second refresh)
ItemA 1000
ItemB 2555
ItemC 3000

I want ItemB to turn red or green if it goes up or down from the most
recent refresh. Or, if that's too complicated just turn a color (or
show some sort of indicator).

Is this possible? Any help is appreciated...
 
List boxes don't have that capability.

One approach often taken is to use a subform (in datasheet view) instead of
the list box. In that way, you can use conditional formatting.

"John" wrote in message

Access 2010

Looking for any pointers. I have a 2 column list box that refreshes at
set intervals. First column is text. Second column is amount, which
can fluctuate at each interval. I'm trying to highlight the amount if
it changes. Sort of like what a stock ticker would do.

LISTBOX
(First refresh)
ItemA 1000
ItemB 2000
ItemC 3000

(Second refresh)
ItemA 1000
ItemB 2555
ItemC 3000

I want ItemB to turn red or green if it goes up or down from the most
recent refresh. Or, if that's too complicated just turn a color (or
show some sort of indicator).

Is this possible? Any help is appreciated...
 
Back
Top