Conditional Formatting question

[Iram]

Hello.
I have a continuous form with about 10 fields in the Detail section of the
form. In the Form Header section I have a regular text box that I can type
into. When I type something into it I would like the fields in the continuous
form that are either exactly identical or kind of like it to change color
using the Conditional Formatting Expression Is feature.
I need an expression that is kind of like...
If I am like "SearchTextBox".
Then I will choose the background color when this condition is met.
Can you help with this expression?


Thanks.
Iram/mcp

 

[fredg]

Hello.
I have a continuous form with about 10 fields in the Detail section of the
form. In the Form Header section I have a regular text box that I can type
into. When I type something into it I would like the fields in the continuous
form that are either exactly identical or kind of like it to change color
using the Conditional Formatting Expression Is feature.
I need an expression that is kind of like...
If I am like "SearchTextBox".
Then I will choose the background color when this condition is met.
Can you help with this expression?

Thanks.
Iram/mcp

What does "or kind of like it" mean?
John is like George as they are both men's names.
Hare is like hair as they both sound similar.
Bare is like bear, pear is like pare
Butter is like putter, etc....
European is like Europe as they both contain the word Europe.
Can't help in that regards as I don't know what it is you are looking
for.

In any event to use the exact word, select the control in the form's
Detail Section.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write
[ThisControlName] = [ControlInHeaderName]
Select the color wanted.
Click OK

Do the same for the other controls on the form.

Change the control names to the actual names you are using.

 

[Iram]

Sorry about the confusion.
I meant it in the sense of a keyword, for instance in a query I use...

Like "*" & [Enter Keyword] & "*"

So If I type in Compl it will search the queried fields that have some form
of Compl like Complaint, Complaints, Complaining, etc.

However in the Conditional Formatting the above does not work. And thats
where I am hoping you can help.
Again, that is why I need something with a Like clause of some sort.

If I am like "SearchTextBox".


Your help is greatly appreciated.
Iram/mcp

Hello.
I have a continuous form with about 10 fields in the Detail section of the
form. In the Form Header section I have a regular text box that I can type
into. When I type something into it I would like the fields in the continuous
form that are either exactly identical or kind of like it to change color
using the Conditional Formatting Expression Is feature.
I need an expression that is kind of like...
If I am like "SearchTextBox".
Then I will choose the background color when this condition is met.
Can you help with this expression?

Thanks.
Iram/mcp

What does "or kind of like it" mean?
John is like George as they are both men's names.
Hare is like hair as they both sound similar.
Bare is like bear, pear is like pare
Butter is like putter, etc....
European is like Europe as they both contain the word Europe.
Can't help in that regards as I don't know what it is you are looking
for.

In any event to use the exact word, select the control in the form's
Detail Section.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write
[ThisControlName] = [ControlInHeaderName]
Select the color wanted.
Click OK

Do the same for the other controls on the form.

Change the control names to the actual names you are using.

 

[fredg]

Sorry about the confusion.
I meant it in the sense of a keyword, for instance in a query I use...

Like "*" & [Enter Keyword] & "*"

So If I type in Compl it will search the queried fields that have some form
of Compl like Complaint, Complaints, Complaining, etc.

However in the Conditional Formatting the above does not work. And thats
where I am hoping you can help.
Again, that is why I need something with a Like clause of some sort.

If I am like "SearchTextBox".

Your help is greatly appreciated.
Iram/mcp

Hello.
I have a continuous form with about 10 fields in the Detail section of the
form. In the Form Header section I have a regular text box that I can type
into. When I type something into it I would like the fields in the continuous
form that are either exactly identical or kind of like it to change color
using the Conditional Formatting Expression Is feature.
I need an expression that is kind of like...
If I am like "SearchTextBox".
Then I will choose the background color when this condition is met.
Can you help with this expression?

Thanks.
Iram/mcp

What does "or kind of like it" mean?
John is like George as they are both men's names.
Hare is like hair as they both sound similar.
Bare is like bear, pear is like pare
Butter is like putter, etc....
European is like Europe as they both contain the word Europe.
Can't help in that regards as I don't know what it is you are looking
for.

In any event to use the exact word, select the control in the form's
Detail Section.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write
[ThisControlName] = [ControlInHeaderName]
Select the color wanted.
Click OK

Do the same for the other controls on the form.

Change the control names to the actual names you are using.

This will work for both exact and if the any part of the value is
within the field:

Expression Is
InStr([ThisControlName],[SearchTextBox]) > 0

 

[Iram]

You are the man!

Thanks.
Iram/mcp

Sorry about the confusion.
I meant it in the sense of a keyword, for instance in a query I use...

Like "*" & [Enter Keyword] & "*"

So If I type in Compl it will search the queried fields that have some form
of Compl like Complaint, Complaints, Complaining, etc.

However in the Conditional Formatting the above does not work. And thats
where I am hoping you can help.
Again, that is why I need something with a Like clause of some sort.

If I am like "SearchTextBox".

Your help is greatly appreciated.
Iram/mcp

On Wed, 29 Oct 2008 11:25:01 -0700, Iram wrote:

Hello.
I have a continuous form with about 10 fields in the Detail section of the
form. In the Form Header section I have a regular text box that I can type
into. When I type something into it I would like the fields in the continuous
form that are either exactly identical or kind of like it to change color
using the Conditional Formatting Expression Is feature.
I need an expression that is kind of like...
If I am like "SearchTextBox".
Then I will choose the background color when this condition is met.
Can you help with this expression?

Thanks.
Iram/mcp

What does "or kind of like it" mean?
John is like George as they are both men's names.
Hare is like hair as they both sound similar.
Bare is like bear, pear is like pare
Butter is like putter, etc....
European is like Europe as they both contain the word Europe.
Can't help in that regards as I don't know what it is you are looking
for.

In any event to use the exact word, select the control in the form's
Detail Section.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write
[ThisControlName] = [ControlInHeaderName]
Select the color wanted.
Click OK

Do the same for the other controls on the form.

Change the control names to the actual names you are using.

This will work for both exact and if the any part of the value is
within the field:

Expression Is
InStr([ThisControlName],[SearchTextBox]) > 0