I would like to find a template in access that is for inventory but includes a column for expiry dates. I want the expiry dates to turn yellow if it expires within 3 months and red if it is over due. I have found a good free access template simply for inventory but doesn't include an expiry function. Does anyone know how I can easily adapt the current access file or know where I can access a template with these possibilities? I am not familiar with Access but need to create a database for equipment. Please help!
-
-
to highlight the field with condition, your only choice is using form Datasheet.
if you have everything you need on table/query, just wanna hightlight them up.
In Access 2010 (2007 somewhat similar), choose the table (dont open it) then go to CREATE section in ribbon, point to more form and choose Datasheet form from droplist.
ok, Access will open your table in Datasheet form. Next, select your collumn that you want to apply conditions, right click on it's title -> select conditional formating at the end of droplist.
now you can set whatever condition you want and choose highlight style you need. -
yikes,
Datasheet is not the only solution.
Conditional formatting will work for continuous forms as well as for reports and so forth.
A very detailed explanation can be found on microsoft's website
Change the appearance of a control by using conditional formatting
Really nice thing, since Acc2007, conditional formatting will even highlight a text field and combobox control with the focus (not the buttons, list boxes, option buttons, though... these require some VBA yet. )Comment
Comment