BorderColor

[la1814]

Having issues getting the BorderColor to turn red in a datasheet form 'Pilot' field when it is empty AfterUpdate. I confirmed the SpecialEffect property is set to flat:

 Private Sub Pilot_AfterUpdate()
    If IsNull(Pilot) = True Then
        Pilot.BorderColor = RGB(255, 0, 0)
    End If
End Sub

Thanks in advance. Happy New Year.

 

[Galaxiom]

Datasheet View does not support BorderColor.

 

[missinglinq]

Most Formatting on Datasheet View Forms has to be done using Conditional Formatting, and you cannot control BorderColor using CF.

In CF you could set the BackColor of the Textbox to a color until the Control is populated. You'd need something like

• Expression Is (from the Condition1 dropdown box)
• In the next box: Nz([YourControlName],"")=""
• Set the BackColor (using the bucket icon)
• Click OK

Linq ;0)>

 

[la1814]

I was afraid that was the case but could not find info to confirm. Thanks and Happy New Year!

 

[missinglinq]

Sorry we had to confirm your fears!

Welcome to the forum and a Happy New Year to you, as well!

Linq ;0)>