View Single Post
  #1  
Old April 29th, 2010, 10:26 PM posted to microsoft.public.access.forms
Toller[_2_]
external usenet poster
 
Posts: 5
Default Conditional format of a control

I have a form that among other things has on it a field called 'EndDate". I
need to add a field that will be conditionally formatted. If the Date is
greater than Enddate, the field is to contain the text "Expired" in red. If
not, the field is to be a blank and transparent. IOW, if the condition is
met, red letters but otherwise, it just disappears.

The field is not in the database. It's for display only.

I've spent 2 hours trying all sorts of things to no avail. How can this be
done?

Thanks.

Eric