Continuous Form - Make top record BOLD font

[JasonKirkland]

In a continuous form, how do you make the top record bold or otherwise conditionally formatted so that it's appearance is different from the other records?

I have tried using DMax and DLast in the header, then tell the fields in the detail section that if their record number matches the DMax (or DLast) value, to make that record BOLD. Unfortunately, I haven't been able to make it work yet. Each record has become bold.

Thanks for the suggestions!

 

[Onyxpurr]

I haven't found the answer to this one yet. Sorry!

 

[JasonKirkland]

I just figured it out.

The form I was using was a subform. I made a new text box on the main form and told it to =[Last], [Last] being the name of the DMax calculated control in the header of my subform.

Next I went to the detail section of the subform and set the conditional formatting of the field to say: [REC#]=[Forms]![F-Tracker Entry]![LAST] If this condition is true then the property was set to BOLD.

I have the records in the subform automatically sort in descending order.

The problem seems to be that a DMax or DLast result is not the same value type as an autonumber field (or something similiar to that).