Anyone spot what's worng here?

J

JethroUK©

using form current event - trying to set background color of fields in
detail section to identify those not completed (null)

For Each ctrl In Detail.Controls
If IsNull(ctrl) And ctrl.Left < 7000 And ctrl.ControlType =
(acTextBox Or acComboBox) Then _
ctrl.BackColor = 255 Else ctrl.BackColor = 10040115
Next

error setting backcolor as unidentified property - anyone see mistake?
 
D

Douglas J Steele

If IsNull(ctrl) And ctrl.Left < 7000 And (ctrl.ControlType =
acTextBox Or ctrl.ControlType = acComboBox) Then _
 
J

JethroUK©

fix it thanks

Douglas J Steele said:
If IsNull(ctrl) And ctrl.Left < 7000 And (ctrl.ControlType =
acTextBox Or ctrl.ControlType = acComboBox) Then _
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top