Solved

acess conditional formatting problem

Posted on 2011-03-02
7
737 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 - Access MVP) 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

Backup Your Microsoft Windows Server®

Backup 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.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

863 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

20 Experts available now in Live!

Get 1:1 Help Now