Conditional Formatting in Access 97

rbliss

New Member
Joined
Aug 13, 2004
Messages
7
I am fairly new to this, so please excuse me for not having the proper verbage.

I have created a report in Access 97, with the following information:

Date open, Expected Date of Completion, and Date Closed.

I run reports weekly on all open items. What I need to do is to be able to format the font to turn red in the Expected Date of Completion field if today's date is after the Expected Date of Completion.

Or another scenario might be:
If today's date is 90 past the Date Open field, then turn the font in the Expected Date of Completion Red.

Please Help! :confused:

Thank you in advance for any suggestions.

Robin
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
Robin

I'm afraid that, as far as I recall, there is no conditional formatting in Access 97.

The only way I think you can do what you want is via VBA, and I'm not 100% sure how you would do that, or if it is in fact possible.

I'll take a look into it and post back.
 

Tanis

Active Member
Joined
Dec 8, 2002
Messages
305
Unfortunately, Access 97 does not have conditional formatting. So, you will have to 'roll your own' In the On Format property of the report put something like this.

Dim YourControlName as String
Const vbRed = 255
Const vbBlack = 0

If Me.YourControlName = YourTest Then
Me.YourControlName.ForeColor = vbRed
Else
Me.YourControlName.ForeColor = vbBlack
End If
 

Watch MrExcel Video

Forum statistics

Threads
1,118,116
Messages
5,570,273
Members
412,316
Latest member
JabirS
Top