I think that a progress bar is not really what you want, though I may be wrong. The answer there is no, not really.

I believe what you are really looking to do is create a chart or graph of temps over time.  If that is the case, Richard covers charts beginning in Access Expert 31.

Take a look at the Sales Chart TechHelp for ideas.  Instead of sales you would be recording temperatures.

I am looking for this type of progress bar. I was able to make it in Ninox but cannot make it as not starting from 0, in FileMaker I can make it as I want but one color. I thought I should be able to make it in access. In both cases I made it with text field like Rick showed in his training. With repeating text characters.

This is what I achieved in FileMaker, I am looking to make something like this in access, Maybe requires some vba but not sure

I could use a series of Text Boxes for this.

I built a progress bar with a similar look, you could recolour the Text Boxes, make them visible/not visible, change the caption of the label (and if necessary move it) with some VBA.

The screenshot below shows my Progress Bar.

Richard This may make a great follow-up to the Progress Bar video.

You could do it with rectangles and lines too. Ooohhh... that would make a good video. :) I'll add it to the list.

Thanks, Richard that would really help me on the database that I am working on for my personal use. I will look forward to your solution, I am sure it will be a treat to watch. In FileMaker I also used it in sub forms to show temp bars in each row ( comparing temp bars for same day over multiple years), like excel, if you could show how that can be done. That would be great.

That looks like something a little closer to Access Project Management.

I used this to create progress bar in Ninox, credits to Andy at Nioxus, whose idea made me come up wth the first  progress bar.( multi color).

Thinking out aloud Can this be replicated in VBA, I am sure there would be a better solution out there but can we somehow make it so that it does not start from left most character, but from current box minus value or current box plus value. I.e if -5 then start from 40 -5 and color white, if 25 then from 40 +25 color green, if 35 then color 40 +30 green and from 70+5 color red.

This gives me two bars, however if I can do above then I should need only one text field to display min and max value

That's definitely a good start. Using those extended ASCII characters with colors is a wonderful idea. I did that before in one of my videos. I can't remember which one, but I think maybe it was the Progress Bar video.

Hi Richard, yes I saw that video but it is going from 0 to 100, I am trying to float between -40 to 60, based on field value. Lower value taken from one field and higher value taken from other field. I could not get it to start from 40, which I am taking as 0, and other values referenced from 40, I am trying to repeat 1 character based on values in field. I think I will need a function to do that  in VBA, but not sure where to start. Any help in guiding me in the right direction would help. I know VBA, fairly well thanks to your tech help classes, but never wrote custom functions.

OK. Sounds like a fun topic for a video.