Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 745
  • Last Modified:

acess conditional formatting problem

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
topUKlawyer
Asked:
topUKlawyer
  • 4
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It works now.  not sure what I did ...

mx
Copy-of-Unregistered-Stored-Deed.zip
0
 
topUKlawyerAuthor Commented:
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
 
peter57rCommented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
topUKlawyerAuthor Commented:
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
 
peter57rCommented:
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
 
topUKlawyerAuthor Commented:
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
 
topUKlawyerAuthor Commented:
sort of joint solution to a strange and possibly unfathomable quirk.

thanks as ever
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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