Changing a color of an individual "cell"

L

LynnInRoch

Hello, I am attempting to change the color of an individual cell -- not the
whole database or even record or even put conditional formating on it. Is
there a way, as in Excel or Word, to change just the color, when determined
necessary by the user, of just one cell? Thanks, Lynn
 
J

Jeff Boyce

This newsgroup supports users of Microsoft Access, a relational database
product. It sounds like you'd get answers quicker by reposting to an Excel
or Word newsgroup.
 
L

LynnInRoch

I appologize -- I see that I didn't even mention that I am using MS Access
and need to know if there's a way to change to color of a particular (and I
know no other name for it other than to call it a "cell" - basically a
portion of a record) on the fly -- such as one would do in Excel or Word
where a single word can be changed just buy highlighting it and using the
font choices. I've tried that and it changes the entire database to red, or
green, or purple - I've tried both in Database view and created a form. I
know I could write some background VB, but I haven't programmed in VB in
yyyeeears -- the conditional formating doesn't allow me to say "if the
projector is an hitachi and the "lenth of time = "hours" and length of time
is over 500, then turn it red. If length of time is designated in Days, and
it's a hitachi and the length of time is over 100, then turn "lamp time" to
red. --- and this must be done for 5 different projectors, each with
different time frames need to set it to red. It's currently in Excel, so
I've imported it into Access. Obviously it would be much simpiler to just
allow each person (we all know what and when we need to make the hours red)
to highlight or do whatever is necessary, to manually make the "hours" red to
make it stand out. I'm suspecting the answer is "no you can't do that, it's
a database you idiot, you're going to have to go back to the recesses of your
mind and just program it in VB..." (as I've searched the web extensively to
find the answer to this question), but perhaps I'm just missing something.
Thank you for your time. Lynn
 
J

Jeff Boyce

Lynn

I'm not quite clear on where you are trying to do this, but suspect you are
trying to treat an Access table as if it were an Excel spreadsheet, or a
Word table.

Access tables store data, Access forms (and reports) display it.

If you want a given field/value to have a color associated with it, consider
doing this in a form, where you have considerable control.
 
L

LynnInRoch

Thank you for your help, Jeff -- I was hoping that because Access is an MS
product that I could carry across the feature of just highlighting an
individual value and changing the color. I knew I probably wouldn't be able
to change it in the database, so I did create a form (just a simple one that
mimics the look of the database because anything more elaborate and we
wouldn't be able to see the information we need to. And whatever I do, I can
not choose an individual value in a particular record and change just that
value to red -- all the values on the entire form turn red. Which, makes
sense in any db, but I was just hoping that MS would simplify this part.
So....off to code I go....Thanks again.
 
J

Jeff Boyce

Actually, Lynn, take a look at Conditional Formatting on that form. I
believe there's a way you can set the control that holds the value to change
color when it holds a particular value (e.g., 17.3).
 
Top