Changing the color in part of a string that is in a text box

[mr879]

Hello I am trying to change the color of part of a string that is in a text box in a form.

Note: This data is extracted from a SQL server so I cannot manipulate the data such as misplace the value in the text box.

ID	MI
1234567891230	123456789123

'if the values are the same then do nothing
If (txtID.Value = txtMI.Value) Then

'if the length of txtID does not equal length of txtMI and Length txtID=13 And the last string value of txtID=0 and the first 12 values of txtID=txtMI
ElseIf (Len(txtID.Value) <> Len(txtMI.Value)) And (Len(txtID.Value) = 13) And (Right(txtID.Value, 1) = 0) And (Left(txtID.Value, 12) = txtMI.Value) Then
'this gets the last value of txtID
lastZero = Right(txtID.Value, 1)

'I have tried to use this but error says object required, I believe because this is not associated with a text box


lastZero.ForeColor = vbRed

End If

[ranman256]

The text box can have only 1 color. (txtID)
lastzero is not a text box and cannot have a color.

[mr879]

I understand that I am asking if there is a way to do it so that I can color only portion of the text.

[ranman256]

No. Text boxes are ALL , not partial.

[mr879]

So I cannot change the color in portion of a string in a text box?

[ranman256]

3rd time: No. All one color.

[ItsMe]

You could use three or more textboxes.

[GraeagleBill]

You'll need to follow the suggestion of ItsMe in that to have one portion of the string a different color than the balance of the string requires distinctively different containers. It gets messy if you have to have a different color somewhere in the midst of the string because of the alignment of the strings. If the information you have allows you clearly identify the leading portion of a string from the trailing portion, two text boxes butted together with the left of the two "right-aligned" and the other "left-aligned" is about the only way you'll be able to present the user with what "appears" to be a single value with a portion being a different color.

[Missinglinq]

From Access 2007 forward, with a Field defined as a Memo Datatype, in Table Design the Text Format Property can be changed from Plain Text to Rich Text, which allows for this kind of thing.

Linq ;0)>