Solved how can i change color of certain characters in string ? (1 Viewer)

VBANewBie :)

Member
Local time
Today, 05:28
Joined
Apr 14, 2021
Messages
86
Hello Guys ,


I have this table named TblCondition and a form that contains a textbox i need a way to colorize some characters in textbox which exists in the TblConditions .

Example : Let’s say the form textbox contains this phrase "Hi my name is Amr 01002503 #$%^#^& "
And my table contains All English letters Like Image
1.png


3.png


Then these characters in textbox will be colorized Red and the rest will stay black Like the image

5.png



I need a flexible way and easy to edit , And I need the table contain another field contains color in case i needed different color for each character.
PS: The table could contain symbols , letters , numbers , any foreign alphabets whatever the content it will be my condition .
It’s alot to ask Thanks in advance .
 

Attachments

  • 2.png
    2.png
    8.4 KB · Views: 186
  • Colorize.accdb
    716 KB · Views: 191

Ranman256

Well-known member
Local time
Yesterday, 23:28
Joined
Apr 9, 2015
Messages
4,102
you cannot color individual characters.
 

SHANEMAC51

Active member
Local time
Today, 06:28
Joined
Jan 28, 2022
Messages
288
coloring of individual characters is possible only in the MEMO field - long text in RTF format
 

SHANEMAC51

Active member
Local time
Today, 06:28
Joined
Jan 28, 2022
Messages
288
you can color directly in the form field, the code is recorded by micro-recording, so having a normal text and the coloring law, it is easy to write a function according to your conditions
 

Attachments

  • 2022-02-04_21-20-42.png
    2022-02-04_21-20-42.png
    6.9 KB · Views: 104
Last edited:

isladogs

CID VIP
Local time
Today, 04:28
Joined
Jan 14, 2017
Messages
16,219
This is an example of rich text in a long text (memo) field. As already stated, it isn't possible for short text fields.
RichText.PNG
 

Users who are viewing this thread

Top Bottom