Bold or Color certain records in split form

[data808]

I was wondering if it was possible to bold or color text in a split form based on if certain values are present within that record?

For example, say the record has 3 text boxes (txtbox1, txtbox2, and txtbox3), if txtbox3 has the value of a certain word like "tree" then txtbox1 will be bold.

Is this possible in a split form where all the records are showing in a list?

Thanks.

[Gicu]

Maybe try conditional formatting?

[data808]

Maybe try conditional formatting?

Hi Gicu!

Yeah I looked at it a bit but from what I could tell, it seems that it will only allow me to change the text box I select to do the conditional formatting on. I'm not sure how to make one text box change conditions based on another text box's conditions. If that makes sense. Do you know if this is possible? If so, I can try and mess with it more to figure it out.

Thanks for the reply.

[Micron]

Is "tree" the only word in txtbox3 or is tree part of a longer string?

[CJ_London]

it seems that it will only allow me to change the text box I select to do the conditional formatting on

. Not true - select all the controls you want to format then use expression is and a formula such as

=[txtbox3] like “*tree*”

[data808]

Is "tree" the only word in txtbox3 or is tree part of a longer string?

Tree was an example. More accurately it will have a number in front of abbreviations so it needs to be specific. Here are some examples:


2 SUP/DC
2 SUP CS1/2
3 ADMIN

So the examples above are for txtbox3 values. If txtbox3 has any of those values, I want txtbox1's value to be bold. I should also mention that txtbox3 is a combo box with a list of values. Here are all the values for that box:

1 USER CS1/2
1 USER DC
2 SUP/DC
2 SUP CS1/2
3 ADMIN

So basically only if txtbox3 has the bottom 3 values listed above, I would want txtbox1 to be bold.

[data808]

. Not true - select all the controls you want to format then use expression is and a formula such as

=[txtbox3] like “*tree*”

Thanks. I think I want something more specific than using like. See post #6 as I listed the values involved.

[Gicu]

Try
If Left ([cboYourCombo],1) In ("2","3")

[data808]

Try
If Left ([cboYourCombo],1) In ("2","3")

Not very good with the expressions so I been trying to use VBA. I put this in the On Current event of the split form and it's not working:

If Me.combox.Value = "3 Admin" Then
Me.txtbox1.FontBold = True
End If

Do you know why this code doesn't work?

[Welshgasman]

Have you walked through the code to see where it goes?
You have gone from a textbox to a combo now? Do you have Option Explicit at the top of your form?

You also said

I should also mention that txtbox3 is a combo box

[data808]

Have you walked through the code to see where it goes?
You have gone from a textbox to a combo now? Do you have Option Explicit at the top of your form?

You also said [/COLOR]

Yeah it's split form with a combo box that has a list of values for the user to choose from. The split form shows the whole recordset so I think VBA doesn't quite work the same way as just a regular form because I'm pretty sure if it was a regular form that code I pasted above would probably work with no problems. Basically I just want the split form to show all records that have "3 Admin" for the combo box, make the text box 1's values to be bold. Those are basically the people that have admin rights. If that makes sense.

So I wrote this:

If Me.combox.Value = "3 Admin" Then
Me.txtbox1.FontBold = True
End If

in the On Current event of the split form and no records are showing bold for text box 1 which is basically the clerk's name.

[Welshgasman]

The code will make the control bold in the one part of the single form, but not the datasheet part.
I have just tried on a form of mine.

I started using what I called and Emulated Split Form (ESF) in place of a split form, however tryng to do it on that which is actually a continuous form affects every record despite being bound?

[Gicu]

As mentioned the Current event won't trigger in the datasheet portion of the split form so conditional formatting would be the only option I can suggest. And keep in mind that the combo's value is based on its bound column not what is displayed (usually the bound column is a numeric ID and hidden).
Cheers,

[data808]

As mentioned the Current event won't trigger in the datasheet portion of the split form so conditional formatting would be the only option I can suggest. And keep in mind that the combo's value is based on its bound column not what is displayed (usually the bound column is a numeric ID and hidden).
Cheers,

Thanks.

Ok I clicked the combo box on the bottom where the datasheet section is for design view and went to conditional formatting and selected a new rule. I then selected "Expression Is" and pasted this into the field next to it:

If Left ([cmbSplitUserSecurity],1) In ("2","3")

I get an error message saying "The expression you entered contains invalid syntax. You may have entered an operand without an operator."

So then I did the same thing for one of the text boxes that I wanted to be bold, if the combo box contained a certain value (3 ADMIN) and I get the same error message.

Do I need to add something else to the expression? How does it know to make the other text boxes bold?

Thanks Gicu.

[Micron]

Erroneous statement, apparently, so removed.