Conditional formatting on demand

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have seen that is easy to change the color of a form texbox by criteria
using Conditional Formatting.
I‘d like to be able to use or not the pre set conditional formatting on
demand. I.e. to put a command button on the form and when it is selecte to
apply conditional formatting otherwise not.
Is it possible and how ?

Thank you
GL
 
Hi,

I have seen that is easy to change the color of a form texbox by criteria
using Conditional Formatting.
I¡d like to be able to use or not the pre set conditional formatting on
demand. I.e. to put a command button on the form and when it is selecte to
apply conditional formatting otherwise not.
Is it possible and how ?

Thank you
GL
Click to expand...

Add a Ciommand Button to the Form Footer (or Header)
Also add a check box control to the Form Footer (or Header)
Set the check box Default Value to 0 (or -1)
You can make the check box Not Visible.

Code the command button click event:
[CheckBoxName] = Not [CheckBoxName]


Select the control you wish to Format.
Click on Conditional Formatting.
Set the Condition1 drop-down to Expression Is
As the expression, write:

[SomeControl] = Criteria and [CheckBoxName] = True
 
GL said:
Hi,

I have seen that is easy to change the color of a form texbox by criteria
using Conditional Formatting.
I'd like to be able to use or not the pre set conditional formatting on
demand. I.e. to put a command button on the form and when it is selecte to
apply conditional formatting otherwise not.
Is it possible and how ?

Thank you
GL
Click to expand...

=====================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
==========================================================
 
Back
Top