Underlining part of a string in VBA to appear in a form's text box.

[IncidentalProgrammer]

I've found a few results on this through Google, but nothing that's worked for me. I think the problem is that the strings I'm trying to do this to include < and >, and those are specifically the items I need to underline.



I'm writing a module to take a $ value that the user enters in one text box, compare it to some pre-defined ranges, and then set the correct range into a locked text box (the ranges are to help categorize account sizes, so they do need to be ranges). The text I want to appear in the locked text box is stuff like this: ">$250K & <$750K".

I've tried several things I found. The most recent was to convert that field to Memo, and change to Rich Text, then type in this for one of my brackets:

    Dim repValue As Currency
    Dim Minor As String
    Dim Small As String
    Dim Mid As String
    Dim Large As String
    Dim Major As String

 Minor = "<u>" < "</u> & $25K"

I haven't gotten very far with it. I wanted to make sure I had the syntax down, before writing them all. Does anyone know what I'm doing wrong?

[June7]

Review https://www.accessforums.net/access/...eld-47147.html

Search forum on topic: html tags textbox
User: June7

Should see 4 more threads.

[IncidentalProgrammer]

Maybe I'm misunderstanding, but I couldn't find how to make these characters show up in the field.

I tried tweaking my method a little bit, and put them into a table, in hopes that I could then code it to make the right selection in a combo box that would already have the values as I want them, but I'm getting bizarre results.

My table says ">$250K & <$750K", while my combo box pulling from it says "<div>&gt;$250K &amp; <u>&lt;</u>$750K</div>".

[June7]

Did you review the referenced thread? HTML tags only work in textbox set for Rich Text and, AFAIK, only when formatted with the Rich Text toolbar.

Might find this of interest http://www.lebans.com/listboxenhanced.htm