Using VBA to Change a String's FORE and BACKGROUND Colors

[mredmond13]

I have an unbound text box into which I use VBA to load a string. I am reading through a small table to get "tag" words associated with a transaction and I build a string. The code for this is below:

    
    Do While Not rs.EOF
        If Len(CaseTags) > 0 Then
            CaseTags = CaseTags & ",  " & "<font color=red>" & rs!TagTitleMinor & "</font>"
        Else
            CaseTags = "  " & "<font color=red>" & rs!TagTitleMinor & "</font>"
        End If
        rs.MoveNext
    Loop

I change the ControlSource of the text box and it shows up as follows:



Is there any way to change the font background color - not the background of the entire text box, just the string text? For example, black text on a gray background in a white text box.
Thanks in advance.

[June7]

Have to say no. I don't think even RichTextFormat could accomplish that.

[CJ_London]

If I've understood correctly I have to disagree. You can achieve something like this



See this link

https://www.access-programmers.co.uk...ight=rich+text

for a small app so you can see the codes required

but in principle you need

<font style="BACKGROUND-COLOR:#FFFF00">your text here</font>

[isladogs]

Something like this e.g. record 5



To do this, I have a memo field formatted in the table as rich text
The form shows that field as rich text on the left & as plain text on the right so you can see the HTML code tags

If that's what you want you should be able to use VBA to modify the appearance as required e.g. on button click

[mredmond13]

If I've understood correctly I have to disagree. You can achieve something like this



See this link

https://www.access-programmers.co.uk...ight=rich+text

for a small app so you can see the codes required

but in principle you need

<font style="BACKGROUND-COLOR:#FFFF00">your text here</font>

This looks like exactly what I need. I'll give it shot and let you know.
Thanks.

[mredmond13]

Something like this e.g. record 5



To do this, I have a memo field formatted in the table as rich text
The form shows that field as rich text on the left & as plain text on the right so you can see the HTML code tags

If that's what you want you should be able to use VBA to modify the appearance as required e.g. on button click

And this is even more than what I need. Thanks. I'll give them a try and let you know.

[isladogs]

On behalf of Ajax and myself, you're welcome.
Its quite easy once you get the hang of it

[mredmond13]

On behalf of Ajax and myself, you're welcome.
Its quite easy once you get the hang of it

Can I complicate the questions a bit??

In the effort to make this look kinda like a button, can the text have borders? In WORD, I can put borders around a word and recording a macro while doing it generates the code to do it. Can that be applied to Access?

[June7]

Of course, HTML <div> tag. Knew I should have done test before putting foot in mouth. Glad to be corrected.

Now does div have border property? For tutorial on HTML visit https://www.w3schools.com/html/default.asp

[isladogs]

Can I complicate the questions a bit??

In the effort to make this look kinda like a button, can the text have borders? In WORD, I can put borders around a word and recording a macro while doing it generates the code to do it. Can that be applied to Access?

Not sure what you mean - how about a screenshot?
Access doesn't have a macro recorder
If you want it to look like a button, why not use a ...button?! Or a label can be made to look like a button

[CJ_London]

revised in next post

[CJ_London]

can the text have borders?

html code should be the same if it exists, but whether an access richtext textbox will display it correctly I don't know, you'll have to try it. I think the word formatting is specific to Word and is similar to formatting borders around access controls - i.e. is not something that translates to html. Suggest save a word document with this feature as a html document, then inspect the underlying html code.

[mredmond13]

Not sure what you mean - how about a screenshot?
Access doesn't have a macro recorder
If you want it to look like a button, why not use a ...button?! Or a label can be made to look like a button

No, the macro recorder in WORD shows the code that word uses to put the border around a word. I'd like it to look something like the following:


I found a link that shows how to do it in HTML, but it applies to <p>. I couldn't make it work with <font>. Maybe some of you more experienced users know how.

https://www.computerhope.com/issues/ch001392.htm

[June7]

Did some testing this time - div tag can have style element but border attribute isn't working in textbox. The RTF toolbar has an underscore (produces a <u> tag). There is a GRIDLINES icon on the ribbon Text Formatting toolbar which is disabled and that icon does not show on the RTF mini-toolbar. That icon is active for table/query/datasheet form. Possibly an outline box in textbox is beyond Access - too graphical.

[isladogs]

As I understand it, rich text is a subset of HTML and not all HTML tags are supported
I tried using the <span> tag but it didn't work : https://www.w3schools.com/html/html_blocks.asp

TBH I think, if its possible to do, it would probably look a mess having text with a border inside a text box