Changing the colour if given condition occurs

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Five headings on my form. 4 numbers under each heading. Can I make the colour
of the font of the headings change if the numbers meet a criteria?
 
In design view for the form, highlight the control you want to have change
color if conditions are met, then use Conditional Formatting.

You don't mention which version of Access you're using, so it's tough to
tell you where to look for it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
My headings are five name. I'm using Access 2007.
I can send my program. It's 2.6 megs.
Thank you.
Ron
 
My headings are text boxes. There are 4 prices under each heading. If 3 or 4
prices go up - green text. If 2 go up and 2 down - orange text. If 3 or 4 go
down - red text. I hope this explains it better. Ron
 
My headings are text boxes. There are 4 prices under each heading. If 3 or 4
prices go up - green text. If 2 go up and 2 down - orange text. If 3 or 4 go
down - red text. I hope this explains it better. Ron
Click to expand...

No.

Your tables are basic. Please explain the structure of your tables -
tablename, fieldnames, datatypes, relationships.

Then explain the form - its Recordsource (tablename or post the SQL if it's a
query), and explain what the "heading" is (since Heading is not an Access
term, it must be something specific to your application).
 
There is no database. It's a stand alone form. I use it with grade 7 and 8
kids. It's a financial literacy program. There are 10 rounds where the
students buy stocks. After each round, I enter the new prices (using a
formula on a calculator) beside each stock. Once prices have been copied into
the Trading Report, I click on the ROUND button and these NEW prices move
into the OLD prices boxes and we have another trading round. It is not
dependent on any other form. 5 sectors, 4 companies per sector. These
companies are just names that do not appear in any database. Besind each
company are OLD price, NEW price text boxes. I can send it to someone if you
care to look at it. It's a scoreboard and I enter prices manually. I cannot
expound any further. I hope someone can help.
 
Ron

If you aren't saving values in tables, what (and how) is Access supposed to
"remember"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for the prompt reply Jeff. It doesn't remember anything. There's a
reset button to return all the values to zero but that's only used just
before we start a new stock challenge market with another class. The program
is 2.5 megs so I can mail it to you if you want to look at it (without
commitment on your part). Then you might understand the simplicity of our
"price board", as we call it. We are three retired teachers and we go to
different schools to do a financial literace program with grades 7s and 8s.
We paid a gentleman in this discussion group to add the two timers. Other
than that, there is no other files. There's just this little form.
Thank you for all your patience. Ron
 
In addition: It must remember "something" because we can go back to past
ROUNDS and see the previous prices of stocks. I don't know if that helps.??
 
That's "literacy" and "There ARE no other files".

Ron said:
Thanks for the prompt reply Jeff. It doesn't remember anything. There's a
reset button to return all the values to zero but that's only used just
before we start a new stock challenge market with another class. The program
is 2.5 megs so I can mail it to you if you want to look at it (without
commitment on your part). Then you might understand the simplicity of our
"price board", as we call it. We are three retired teachers and we go to
different schools to do a financial literace program with grades 7s and 8s.
We paid a gentleman in this discussion group to add the two timers. Other
than that, there is no other files. There's just this little form.
Thank you for all your patience. Ron
Click to expand...
 
Ron

1. I'll urge you to re-check ... if it's saving values, it's either storing
them in tables (most likely) or hard coding them into the code (much more
difficult, much less likely, much more dangerous!). You need to figure out
where it's saving the values.
2. You probably won't find any takers in this newsgroup for you sending a
copy. After all, would YOU open a file you received from someone you don't
know? (hint: ... JUST SAY NO!)

Regards

Jeff Boyce
Microsoft Office/Access MVP


Ron said:
In addition: It must remember "something" because we can go back to past
ROUNDS and see the previous prices of stocks. I don't know if that
helps.??
Click to expand...
 
You're probably right about opening a file from someone you don't know. The
way I see it, you guys are the experts so you must be protected from such
things. Just say "yes".
Thanks to everyone who took the time to look at my problem. We can do
without colors, I guess.
Again, thank you.
 
ROn

The best definition I ever saw for "expert" ... someone who's made more
mistakes than you.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You're probably right about opening a file from someone you don't know. The
way I see it, you guys are the experts so you must be protected from such
things. Just say "yes".
Click to expand...

Well... no more protected than anybody else. We don't work for Microsoft, we
don't get any special software, etc. We may have been burned a bit more often
than some so we know some of what to watch out for.
Thanks to everyone who took the time to look at my problem. We can do
without colors, I guess.
Again, thank you.
Click to expand...

I'll take a gamble: right click the file in Windows Explorer, select Send
To... Compressed (zipped) Folder and email me the zip file at jvinson <at>
wysard of info <dot> com. I'll see if I can figure out what it's doing. Please
reiterate your view of the problem in the email, with enough detail that
someone not familiar with the program or with your operation would be able to
follow it.
 
Back
Top