Re: If/Then that changes a fields backcolor


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: Opening Form
    ... Microsoft Office/Access MVP ... The form does open with empty fields, however I get a code error when ... That's why I was trying to use code to make the text boxes empty. ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Match value with combo
    ... Disregard the "cant do this with Access" message. ... It is SPAM. ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.forms)
  • Re: no date.... move upwards
    ... Jeff Boyce wrote: ... So you're saying that you want to see NOTHING for that control when there's nothing in the field? ... If data of line1 is empty, line 2 should get top 0,6cm instead of 1,099cm ... It may be that you can use the CanGrow and CanShrink properties of the controls to accommodate records without certain data... ...
    (microsoft.public.access.reports)
  • OT who was the person wanting stuff moving to Germany?
    ... Scotland to Berlin...a guy posted on a German website i use. ... saying its ... empty going 1 way, ok Berlin isnt muenchen, aber its a lot closer.. ... cos i cant afford to move yet ...
    (uk.adverts.computer)
  • Re: delete directory
    ... On 2005-04-07, Houston CAPCOM wrote: ... > I am trying to use rmdir to delete a directory that is not empty and I ... > cant do it. ...
    (alt.os.linux.suse)