Continuous Form : Conditional Formatting

[amrut]

I have applied conditional formatting for a continuous form based on the date. The form (subform )displays all dates of month and if a particular day is a holiday, the row has to be highlighted. In other words, the formatting fails to apply if the holiday is at the start of the month.I have tested for few dates and 12th was the earliest date where formatting was applied successfully.I have holidays stored in a different table and I have used [MyDateField]=Dlookup("HolidayDate","Holidays") as condition for formatting.

Is there a way to re-apply the formatting after the form is completely loaded ? When the data is loaded in any form, when does the conditional formatting (sequence of events) takes place ?

[Missinglinq]

I don't think that timing is the problem, here! You don't have any Value for the Criteria portion of the DLookup Function, and if you don't supply a Value for Criteria, DLookup returns a random value from the Table or Query, it doesn't tell you, in this case, if [MyDateField] is found in the Holidays Table.

I think you actually need to use 'Expression Is' under the 'Condition' dropdown, and then use DCount, like this, for the condition

DCount("*", "Holidays", "[HolidayDate] = #" & [MyDateField] & "#")> 0

Linq ;0)>

[amrut]

Thanks, Missinglinq. DCount("*", "Holidays", "[HolidayDate] = #" & Format([MyDateField],"mm\/dd\/yyyy") & "#")> 0 is working!!

The problem was with the date format as well.



A new thing I learnt "if you don't supply a Value for Criteria, DLookup returns a random value from the Table or Query"