formating text control conditioning with another

[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.

 

[fredg]

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.

 

[alf]

Can I call custom functions in the Conditional Formatting ???

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.

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.

 

[alf]

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.

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.

 

[Tom Ross]

invisible can be achieved with white forground and background colors

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.

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.

 

[alf]

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.

invisible can be achieved with white forground and background colors

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.

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.

 

[Stephen Lebans]

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.

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.

invisible can be achieved with white forground and background colors


Formatting
offert

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.