Conditional formatting for text boxes with same tag

[Ruegen]

I've tagged a bunch of boxes with the same tag in the properties.



"greyout"

I want to apply a conditional formatting to those textboxes with that tag if a value is true.

so if checkboxed then

greyout all boxes with conditional formatting.

I'm thinking along the lines of..

Dim ctl As Control

If JoiningSchool = True Then
For Each ctl In Me.Controls
If ctl.Tag = "greyout" Then

How?

[ssanfu]

Very close...

When you say "greyout", do you want them to be disabled?

try:

    Dim ctl As Control

    If JoiningSchool = True Then
        For Each ctl In Me.Controls
            If ctl.Tag = "greyout" Then
                ctl.Enabled = False
            End If
        Next
    Else
        'JoiningSchool = False
        For Each ctl In Me.Controls
            If ctl.Tag = "greyout" Then
                ctl.Enabled = True
            End If
        Next
    End If

[Ruegen]

Nah, it's a subform and I just block out the whole subform. However I would like to know how to apply conditional formatting to anything with the tag. (I want to change from colour to grey so the user knows they don't have access to it).

[pbaldy]

Or simply

For Each ctl In Me.Controls
  If ctl.Tag = "greyout" Then
    ctl.Enabled = Not JoiningSchool
  End If
Next

[Ruegen]

Or simply

For Each ctl In Me.Controls
  If ctl.Tag = "greyout" Then
    ctl.Enabled = Not JoiningSchool
  End If
Next

thanks but I'm actually after changing the formatting (although I will be using your code supplied)

[ssanfu]

(I want to change from colour to grey

What color?? The font or the background?

so the user knows they don't have access to it).

How does changing the color limit access??

[Ruegen]

What color?? The font or the background?


How does changing the color limit access??

heh it doesn't, but combined with locked it gives them a visual feedback before they have tried to click in the field. Yes, Font and background color.

[ssanfu]

In your form, change a control for the enabled property to NO. The background and the font colors change.
As a bonus, you cannot make changes or even set the focus to the control.

Is that what you want?