Solved

acess conditional formatting problem

Posted on 2011-03-02
7
740 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

730 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