?
Solved

acess conditional formatting problem

Posted on 2011-03-02
7
Medium Priority
?
750 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 Access MVP) earned 1000 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 1000 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 

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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

589 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