Solved

Conditional Formatting in Access 2013

Posted on 2013-06-24
11
2,172 Views
Last Modified: 2013-06-28
Does anyone have any idea why the Conditional Formatting button in Access 2013 is not working?

The button is there under formatting, I can click it but it won't bring up the dialogue box.

Please help.

Thanks,
E
0
Comment
Question by:eantar
  • 4
  • 4
  • 3
11 Comments
 
LVL 4

Expert Comment

by:rubech
Comment Utility
Hi E, have you selected the field you want to work with?

Ruben
0
 
LVL 5

Author Comment

by:eantar
Comment Utility
Yeah. It's really a pain. It just won't pop the rules manager.

I have to right click and get it from the shortcut menu.

E
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Good question. Mine is not working either.
Only right clicking - say over a text box - and selecting CF works.

odd.


mx
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
It clearly works in A2010. VERY odd.
0
 
LVL 5

Author Comment

by:eantar
Comment Utility
Yup.

E
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 4

Expert Comment

by:rubech
Comment Utility
Not so odd with Microsoft!

Can you try removing the button from the ribbon and adding it again, sometimes it resets the button

Give it a try

Ruben
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
I added CF to the QAT and that works.

It doesn't appear you and Remove & Re-Add CF by itself, as it's part of the Control Formatting Group. I could try a Reset, but ... I don't want to have to redo my QAT.

I also tried adding a new Group on the Format tab and adding CF to that. However, that did not work ... same issue.  Odd that you can add to QAT and it works !!

mx

CF
0
 
LVL 4

Assisted Solution

by:rubech
rubech earned 250 total points
Comment Utility
Good to know you solved the issue and to know a workaround

Ruben
0
 
LVL 5

Author Comment

by:eantar
Comment Utility
Thanks mx. But what's QAT?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
Comment Utility
QAT = Quick Access Toolbar - which can be customized independent of the Ribbon.

"Good to know you solved the issue"
Well, not really - but I did find a workaround. This really seems to be a big, unless we are really missing something.
If no one has the answer, I will report  to our MVP Dist List and to Microsoft.

mx
0
 
LVL 5

Author Closing Comment

by:eantar
Comment Utility
Hey guys, thanks for help with this.

I gotta tell ya, I ready to put Office 2010 back. Such problems with Outlook, Word and even Access. I've had to run the Repair from Setup a couple of times.

You???

Eddie
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now