formating text control conditioning with another

  • Thread starter Thread starter alf
  • Start date Start date
A

alf

Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.
 
Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.
Click to expand...

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
 
Can I call custom functions in the Conditional Formatting ???

Thanks, alf.

fredg said:
Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.
Click to expand...

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
Click to expand...
 
another one question :

Is possible to extend the properties that the Conditional Formatting offert
?? ex: visible, or any other not present there ???

thanks again, alf.

fredg said:
Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.
Click to expand...

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
Click to expand...
 
invisible can be achieved with white forground and background colors


alf said:
another one question :

Is possible to extend the properties that the Conditional Formatting offert
?? ex: visible, or any other not present there ???

thanks again, alf.

fredg said:
Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.
Click to expand...

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
Click to expand...
Click to expand...
 
the bakcground color of the form is not white, so I need a non standar
color to get the invisible effect but the Conditional Formatting not have
the possibility to create custom colors..
now what ?????
thanks, alf.

Tom Ross said:
invisible can be achieved with white forground and background colors


alf said:
another one question :

Is possible to extend the properties that the Conditional Formatting offert
?? ex: visible, or any other not present there ???

thanks again, alf.

fredg said:
On Tue, 25 Nov 2003 11:46:41 -0500, alf wrote:

Hi:
I'm trying to do the follow:
Text1 shows field1 in red text if field2=1
and
Text1 shows field1 in blue text if field2=2

using a continuos form, because in single form is a simple the solution.
The idea is to get in the same repeated control the value of field1 in
different format deppending the value of field2.

any idea ???
thanks, alf.

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
Click to expand...
Click to expand...
Click to expand...
 
You can programmatically modify the FormatConditions object. THis will
alow you to specify any RGB color you want. For sample code see:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


alf said:
the bakcground color of the form is not white, so I need a non standar
color to get the invisible effect but the Conditional Formatting not have
the possibility to create custom colors..
now what ?????
thanks, alf.

Tom Ross said:
invisible can be achieved with white forground and background colors


Formatting
offert
Click to expand...
field1
in
different format deppending the value of field2.

any idea ???
thanks, alf.

What version of Access?
If your using Access 2000 or newer, click on the [Text1] control.
Then click on Format + Conditional Formatting.
In the Condition 1 drop-down box select
Expression Is
In the Text box along side the drop-down, write:
[Field2] = 2
Click on the Condition 1 Bold tool button.
Save the dialog and run the form.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top