Re: If/Then that changes a fields backcolor

Tech-Archive recommends: Fix windows errors by optimizing your registry


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: Using an unbound texbox to find a record in form
    ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Private Sub Command146_Click ... Dim rec As DAO.Recordset ...
    (microsoft.public.access.queries)
  • Re: User access his own records
    ... I'm guessing you'll need to re-evaluate after each record is loaded. ... conditional formatting in every one of them. ... The textbox is bound to ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Alpha key to surrogate key
    ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... if the customer master table is in the form. ... that a surrogate key would speed things up although, ...
    (microsoft.public.access.formscoding)
  • Re: Which the best option ?
    ... How are Cars related to People? ... One Person can have many pieces of Equipment. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Which the best option ?
    ... set up the tables so that there is something in common between the ... You have to tell the database ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)