• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2332
  • Last Modified:

Conditional Formatting in Access 2013

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
eantar
Asked:
eantar
  • 4
  • 4
  • 3
2 Solutions
 
Ruben CornejoCINCommented:
Hi E, have you selected the field you want to work with?

Ruben
0
 
eantarAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Good question. Mine is not working either.
Only right clicking - say over a text box - and selecting CF works.

odd.


mx
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
It clearly works in A2010. VERY odd.
0
 
eantarAuthor Commented:
Yup.

E
0
 
Ruben CornejoCINCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Ruben CornejoCINCommented:
Good to know you solved the issue and to know a workaround

Ruben
0
 
eantarAuthor Commented:
Thanks mx. But what's QAT?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
eantarAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now