Solved Highlight Matching keywords with red Color.

[smtazulislam]

Hello, I have a Search Form and two search textboxes.
I want to two textboxes keyword search Highlighting in this subform with red Color.

my Subform is not Query or SQL. It has an expression into Control Source.
any help be appreciated.

 

[arnelgp]

can you use Conditional Format?

 

[smtazulislam]

can you use Conditional Format?

Thanks arnel. Can't use conditional format. because this is an expression ref to display not data type.

 

[CJ_London]

my Subform is not Query or SQL. It has an expression into Control Source.

subforms do not have controlsources, they have sourceobject. Do you mean a listbox?

 

[smtazulislam]

subforms do not have controlsources, they have sourceobject. Do you mean a listbox?

subform textbox Control Sources :

=([cName] & " " & "◄►" & " " & "Hex #:" & " " & [hex] & " " & "◄►" & " " & "RGB" & " " & "[" & "R=" & [R] & " " & "G=" & [G] & " " & "B=" & [B] & "]" & " " & "◄►" & " " & "MS Access #:" & " " & [a])

Form SQL like that:

SELECT Colors.ID, Colors.cName, Colors.hex, Colors.cInitial, Colors.R, Colors.G, Colors.B, Colors.A
FROM Colors
ORDER BY Colors.cName;

 

[smtazulislam]

Here output is one color via 4 Method,
I doubt that I don't explain you's guy as well, so, I upload this db.

 

[arnelgp]

I only add Conditional Format to ColorName

 

[CJ_London]

if you put your formula into your subform recordsource you can use richtext to highlight the search text. See attached - not I have disabled most of your code to demonstrate the principle.

 

[smtazulislam]

if you put your formula into your subform recordsource you can use richtext to highlight the search text. See attached - not I have disabled most of your code to demonstrate the principle.

Thank you so much for help. Exactly I wanting like that, but it not shake when Type data, I put it ON CHANGE event but not being good result. and you see also HEX search box not work. I try to requery but not success.
if more help would be greatly appreciated.

 

[smtazulislam]

I only add Conditional Format to ColorName

Thanks for help, I appreciate.
I apologize to say, I wanting letter will be RED color when searching. But your suggestion also good and colorful. Thanks again.

 

[CJ_London]

it is just an example since it is not clear to me the real requirement - you will need to modify code to include Hex - or you could just put a hex value in the search text box and change the label caption to something like 'Search'

 

[smtazulislam]

Hello, anyone help this issue please.....

 

[CJ_London]

if you want to use the change event, in the query you need to reference the .text property of the control

 

[arnelgp]

see FrmSearch2 and the code behind.
i added another field DisplayText, the content
of which is the Original display of the textbox on subform.
you cannot highlight it since it is continuous form and
the Textbox need to be Bound.

theres a lot of code just to have a makeup.

 

[smtazulislam]

see FrmSearch2 and the code behind.
i added another field DisplayText, the content
of which is the Original display of the textbox on subform.
you cannot highlight it since it is continuous form and
the Textbox need to be Bound.

theres a lot of code just to have a makeup.

Thanks you so much arnelgp . its great looking now. I see On_Change Event in your code. But why data not sorting when I typing search boxes. Can you check it again please.
If not sorting, dont have benefit, Bcoz there have 200+ rows.

 

[smtazulislam]

there a lot of code just to have a makeup.

Actually, someone requested me to help her project, that I take and work this db and some of code from me some from herself.

 

[arnelgp]

check if this will sort.

 

[smtazulislam]

check if this will sort.

No work.
I meant, when I typing in the search boxes then subform data will be sorting which data has matched, if not match subform will blank. but here not changing subform data.

 

[arnelgp]

I thought you only wanted to Sort.
test again.

 

[smtazulislam]

I thought you only wanted to Sort.
test again.

Thank you so much arnelgp . I really appreciated nice job. both thanks you again.