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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,552
Messages
5,838,063
Members
430,527
Latest member
MyFace2

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
Top