Solved

acess conditional formatting problem

Posted on 2011-03-02
7
739 Views
Last Modified: 2012-05-11
for some reason which i do not understand i cannot format conditionally the
text box "surname~ in th attched form (Master list) to show a different font colour background colour when
the check box "instructions accepted" is clicked.

BUT i can do it with the "comments" memo box.

why is this?

attched
Copy-of-Unregistered-Stored-Deed.mdb
0
Comment
Question by:topUKlawyer
  • 4
  • 2
7 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 35024915
It works now.  not sure what I did ...

mx
Copy-of-Unregistered-Stored-Deed.zip
0
 

Author Comment

by:topUKlawyer
ID: 35024987
if only things were so easy....!


the one you sent back still works on the comments box but not on surnames!

must be my computer but why?
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
ID: 35025057
I found that just changing the rule from 'Expression Is' to 'Field Has Focus' and back again was sufficient to get the rule to work.
Looks like some internal setting has got lost.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:topUKlawyer
ID: 35025503
hm i tried that once and it worked but then when i went back into it it didnt


i tried to do the same thing again and didnt!



0
 
LVL 77

Expert Comment

by:peter57r
ID: 35025571
I suggest you create a new empty database file and import everything from the current file into it and then test again on the new file.
0
 

Author Comment

by:topUKlawyer
ID: 35025629
see,s to be sorted now


i conditionally formatted it in layout view rather than design view and that worked...

goodness knows why....

Do you!?

0
 

Author Closing Comment

by:topUKlawyer
ID: 35030109
sort of joint solution to a strange and possibly unfathomable quirk.

thanks as ever
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

839 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