What I am looking for is a way to only highlight certain records that are visible on my form without time delays with long continuous forms. The highlighting will be based on a number of values contained in the record.
As an example of what I currently do. Imagine I have a continuous form with one field, [MyDate], being a date. I could place a text box (transparent background and border, Red font colour) to the left of the date and set its control source to =RecentDate([MyDate]) The function RecentDate may be as follows
Function RecentDate(MyDate as Date) as String
if MyDate > Date()-30 then
RecentDate = ">"
RecentDate = ""
This should highlight any record where MyDate is within the last 30 days.
Thank you for your help