Font Change For One Recordset

  • Thread starter Thread starter Karen Howard
  • Start date Start date
K

Karen Howard

Hi,

I have tried "Conditional Formatting" for this problem but
it doesn't work.

What I want to do is: I have a form that has a subform.
I want to be able to apply a "Bold" font to the last entry
(one record) of the subform. I want the remaining
recordsets in the subform to keep the Normal font setting
without being Bold when I print the form's items out in a
report.

How can I accomplish this task? Please help!
 
Karen,

I'm presuming you have a main report and a sub report right now.

If it's not now, base your subreport on a query. Set the criteria of the query
to return all but the last record. Make a copy of the query, call it Query2 and
set the criteria to return the last record.

Make a copy of your existing subreport and call it something like subreport2.
Change the record source to Query2. Install subreport2 immediately below your
existing subreport in the main report.

Now you can format the fields in the last record in subreport2 however you want
independent of all the records preceding the last record in the existing
subreport.
 
Thanks so much for replying to my questions. I tried your
suggestions and they work perfectly!
 
Back
Top