Bold face entry date fields that are past the current date.

[dclarcq]

I am running a report in 2000. One of the fields has a Proposed Book Date
criteria. I would like to have the date or the entire entry highlighted in
Bold if the current date has exceeded the book date.

 

[Allen Browne]

1. Open the report in design view.

2. Select the date field.

3. Choose Conditional Formatting from the Format menu.

4. Set Condition 1 to:
Field Value Is ... less than ... Date()
and click the B(old) button.

 

[dclarcq]

Works perfectly, thank you Allen.

1. Open the report in design view.

2. Select the date field.

3. Choose Conditional Formatting from the Format menu.

4. Set Condition 1 to:
Field Value Is ... less than ... Date()
and click the B(old) button.

 

[dclarcq]

I have a new question about this and it may be for the Word group. When I try
to publish this to Word, the Bold formatting is lost. Any suggestions on how
to keep the Bold when publishing. Thanks.

 

[Allen Browne]

Interesting. I'd never noticed that the RTF file generated when you export
to Word fails to handle the conditional bolding correctly.

You could also use use the Format event of the Detail section to achieve the
formatting, like we used to do in Access 97 and earlier.

Example:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
With Me.[NameOfYourDateControlHere]
If .Value < Date Then
.FontWeight = 400
Else
.FontWeight = 700
End If
End With
End Sub