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
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,686
Messages
6,103,297
Members
447,853
Latest member
olddutch7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top