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

VBANewBie :)

Member
Local time
Tomorrow, 01:43
Joined
Apr 14, 2021
Messages
88
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: 289
  • Colorize.accdb
    716 KB · Views: 308

Ranman256

Well-known member
Local time
Today, 19:43
Joined
Apr 9, 2015
Messages
4,339
you cannot color individual characters.
 

SHANEMAC51

Active member
Local time
Tomorrow, 02:43
Joined
Jan 28, 2022
Messages
310
coloring of individual characters is possible only in the MEMO field - long text in RTF format
 

SHANEMAC51

Active member
Local time
Tomorrow, 02:43
Joined
Jan 28, 2022
Messages
310
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: 198
Last edited:

isladogs

MVP / VIP
Local time
Today, 23:43
Joined
Jan 14, 2017
Messages
18,186
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