greying the entire row in a continous form

[webisti]

Hi Guys

I am using this code to disable a control on a form a split form to be precise:

Private Sub enable()
If IsNull(Me.ORDER) Then
Me.BUY.Enabled = True
Else
Me.BUY.Enabled = False
End If
End Sub

What I am looking for is that in case the ORDER control is not empty, then I want to gray color the entire row.
Any thoughts on that?

Regards

Webisti

[Missinglinq]

This is really simple, with Conditional Formatting. In Form Design View

1. Hold down <Shift> and Left Click on each Control you want Enabled/Disabled, in turn.
2. In pre-2007, on the Menu go to Format - Conditional Format
3. In 2007 and later, on the Ribbon, click on the Design Tab, then Click on the Conditional Icon
4. Under Condition1 use the Down Arrow to select Expression Is
5. In the next box type in Not IsNull([ORDER])
6. Click on the Enabled icon (last icon to the right)
7. Click OK
   

Linq ;0)>

[MarvinM]

DataPig has a good 4½ min video tutorial on conditional formatting you may like:
http://www.datapigtechnologies.com/f...rmatting1.html