Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Is Access 2003 Conditional Formatting broken in Windows 8?

Posted on 2013-01-11
13
Medium Priority
?
773 Views
Last Modified: 2013-01-17
I have always used conditional formatting to color the background of an active row in a continuous form using Access 2003 and Windows 7.  However, I find that in Windows 8 conditional formatting doesn't appear to work other than when the form first opens.  Any real time changes don't seem to happen.

Here's the code I am using:

This runs OnCurrent:
   
'Set Record Selector: 'Form has an unbound field ctlCurrentRecord
    If fTestForControl(frmForm, "ctlCurrentRecord") Then
        ![ctlCurrentRecord] = frmForm.SelTop
        If IsNull(![ID]) Then
        Else
            ![ID].Tag = ![ID].Value    'set ID.Tag
        End If
    End If

Open in new window

And my conditional formatting is set to:

Expression Is: [ID].Tag=[ID]

Open in new window

In the past this has always changed the backcolor of the control "Rowcolor" to a different color for the active record.  In Windows 8 it appears to change it when the form first opens but selecting a new record does not update the color as it did in Windows 7 - the first row remains colored.

Anyone know what is happening here and how I can fix it?

Thanks in advance.
0
Comment
Question by:MitchellVII
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 3
  • +1
13 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 38766698
I haven't actually tried conditional formatting in an Office 2003/Windows 8 setup.

HOWEVER, Windows 8 and Office 2003 are considered to be incompatible... so while some things may work, you are really stretching your luck if you don't follow the recommendations to upgrade to a newer version of Office.
0
 
LVL 58
ID: 38766736
<<HOWEVER, Windows 8 and Office 2003 are considered to be incompatible...>>

Huh...why is that?

Jim.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38766787
Jim,

Unless I'm completely misunderstanding it (again, I have not tested it myself):
http://support.microsoft.com/kb/2777626

MS is using pretty strong language here:


"If you have a Microsoft Office 2003 suite or application on your PC, you will have problems running it on Windows 8. We recommend you upgrade Office to a newer version that is compatible with Windows 8."
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 58
ID: 38766857
<<http://support.microsoft.com/kb/2777626>>

 Typical Microsoft strong arm tactics.   "This won't work", yet they offer nothing of detail as to why.

 And yet Windows 8 includes the desktop specifically so "legacy apps" (non-Metro - oops Metro's out already) can run.

 I don't know of anyone using Access 2000/2003 under Windows 2008 either though, so I can't say the article is off base.

  Their really trying to push Office 2003 out the door....got an e-mail a few weeks ago stating that starting next year, Office 365 will no longer offer POP3 support and there fore will not support Outlook 2003.  

 There's no reason for that.  Even if they wanted to eliminate POP3 (and they'll have a tough time with that), they could have done what they did in the past, which is write a connector to talk to Office 365 (there was a connector for Office Live).

 I love it.  Instead of giving people what they want, they give them what they think they should have and then force them into using it no matter what.

 I do understand not being able to support old software forever, and there may be something fundamental that does make it incompatible, but this seems long a strong arm tactic to me.

 Thanks for the link to the article.

Jim.
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 38766954
<<HOWEVER, Windows 8 and Office 2003 are considered to be incompatible...>>

Not surprising, given that Office 2003 extended support ends in April 2014 :)
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 38766956
Guys, we are turning my question into a discussion of Access 2003 / Windows 8 compatibility.

I am most interested at this point in figuring out what is wrong with conditional formatting.  Seems odd to me that with most things working just fine in Access 2003, this one thing would be broken.

I personally REFUSE to upgrade from Access 2003.  It was the last year they actually got it RIGHT.  Ribbons SUCK.  Navigation Pane SUCKS.  Office 2007 and above is a classic example of MS breaking things that work just fine and ignoring things that are broken.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38766979
<< I am most interested at this point in figuring out what is wrong with conditional formatting>>
Ok - I'll drop out at this point...

You might get other responses, but the real answer very well may be that this and other things are compatibility issues that cannot be fixed.
0
 
LVL 58
ID: 38767083
<<Guys, we are turning my question into a discussion of Access 2003 / Windows 8 compatibility.>>

 Sorry we got a bit side-tracked, but it is germain to the point.  It may not flat out work.

<<I am most interested at this point in figuring out what is wrong with conditional formatting.  Seems odd to me that with most things working just fine in Access 2003, this one thing would be broken.>>

 Does to me to, but then how Windows works has been fundamentally changed.

 I would suggest taking a copy of the DB off the windows 8 machine and try it on another non-windows 8 machine.

  If it works, then it's the Office install under Windows 8.  If it doesn't work, then it's the DB.

  If DB, I would create a new DB and import all objects into it.

  If Office, then I'd run a repair and see if that fixes it.  If not, then it may be a fundamental incompatibility with windows 8

<<I personally REFUSE to upgrade from Access 2003.  It was the last year they actually got it RIGHT.  Ribbons SUCK.  Navigation Pane SUCKS.  Office 2007 and above is a classic example of MS breaking things that work just fine and ignoring things that are broken. >>

  I'm on the same page<g>.  You could scrape by in Access 2007 and 2010 with an old DB (command bars and ULS were supported as long as you did not covert the DB to the new ACE format), but now with Access 2013, you can no longer do that as command bars have been dropped.  So with A2013, it is the ribbon and nothing else.

Jim.
0
 
LVL 5

Author Comment

by:MitchellVII
ID: 38767205
Jim,

Yes, it seems that MS made a choice after 2003 to design for 5 year olds with lots of pretty pictures as opposed to true functionality that adults could enjoy.

Have you ever noticed that every time MS "upgrades" their products, everything takes MORE steps and is HARDER to use?

Can you recommend a good simple method for coloring active rows in Windows 8?

* I've also noticed that Windows 8 doesn't care for calculated values in unbound controls but it doesn't mind if you put the calculation in the underlying query and bind it to the field.  Weird.
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 38767510
<<Can you recommend a good simple method for coloring active rows in Windows 8?>>

 You can revert to the old method, which doesn't rely on condition formatting.  What you do is put a control behind the other controls, set the background on your controls to tranparent, and then fill the background control with a color or graphic.

 I've attached a sample of that.

<<* I've also noticed that Windows 8 doesn't care for calculated values in unbound controls but it doesn't mind if you put the calculation in the underlying query and bind it to the field.  Weird.>>
 
  Hum...can't think of why that would be.

Jim.
ContinuousFormColors.MDB
0
 
LVL 5

Accepted Solution

by:
MitchellVII earned 0 total points
ID: 38770254
Ok, THIS is weird. Conditional formatting just started working again!

Have NO idea what I changed but it is working fine now.  Bizarre.  So apparently conditional formatting for Access 2003 DOES still work under Windows 8.

Will distribute points as best I can.
0
 
LVL 5

Author Closing Comment

by:MitchellVII
ID: 38786389
Just started working all of a sudden.  Thanks everyone.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question