Best way to do a slider in Acc2003

[Blackshark]

Hi,

I would like to have a horizontal slider in an Access Report. So a horizontal scale of 0 to 25, with a vertical bar verticaly through the horizontal bar based on a field value.

It would be nice if I could have three areas (red, amber, green) of background colour set at certain values.

I am thinking of writing a function that moves a line object at run time - is there a FOC ActiveX component out there that I can use instead?


Thanks for all assistance given

Tim

 

[dhookom]

I would use the line method to draw rectangles or possibly resize some text boxes or labels. I would not attempt to find and install an ActiveX control.

There are some calendar report samples at

http://www.access.hookom.net/Samples.htm

that show how to manipulate control positions at runtime.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]