Re: If/Then that changes a fields backcolor

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Again, depending on which version of Access you are using, you might be able
to put more than one condition on that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"kdavis" <kdavis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BBF47D94-5A4C-4ADB-AE70-7A260ED58A26@xxxxxxxxxxxxxxxx
yes, i cant make it take into consideration if the field is empty. I am
looking at formatting some date fields so that as time nears the deadline,
the fields change color from green to yellow to red. I just cant figure
out
how to make it work when the field is empty.
--
Kenny


"Jeff Boyce" wrote:

Have you looked into Conditional Formatting? (you didn't mention which
version of Access...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

"kdavis" <kdavis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E085B7BB-FC09-4E79-9795-87D699234721@xxxxxxxxxxxxxxxx
If I have a field "x" and if it is empty, i want the field to be Green,
however, if the field has a date and that date is less than 7/1/09, I
want
the field to be Yellow.

any ideas?
--
Kenny





.

Relevant Pages

  • Re: Redesign slow database or archive records ?
    ... Wide Area Network to run an Access application. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Initial database entry. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form does not open in design view
    ... You can probably find a copy of JetComp the same way, ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... While I am in design view of this form, I get a memory error - ...
    (microsoft.public.access.forms)
  • Re: Combo box to automatically fill in values
    ... Microsoft Office/Access MVP ... if the OnOpen property of a form is set to =, ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Change Filed type using VB
    ... Jeff Boyce ... Microsoft Office/Access MVP ... An alternative to just "taking it" and changing it via VBA code would be ... to create a table definition in Access that has the field data types you ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Formating Post Import
    ... Depending on which version of Access you are using, ... Jeff Boyce ... Microsoft Office/Access MVP ... Hope everyone had a pleasant holiday weekend. ...
    (microsoft.public.access.queries)