Re: Anyone spot what's worng here?

Tech-Archive recommends: Fix windows errors by optimizing your registry

fix it thanks

"Douglas J Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:uRrWWMRbGHA.4248@xxxxxxxxxxxxxxxxxxxxxxx
If IsNull(ctrl) And ctrl.Left < 7000 And (ctrl.ControlType =
acTextBox Or ctrl.ControlType = acComboBox) Then _


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JethroUK©" <reply@xxxxxxxxx> wrote in message
news:TQk5g.8977$E52.2087@xxxxxxxxxxxxxxxxxxxxxxx
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?








.

Relevant Pages

  • Re: Select Case question
    ... Case acTextBox, acComboBox ... Case acCheckBox ... the header and the results are displayed in a continuous form in the ...
    (comp.databases.ms-access)
  • Re: Anyone spot whats worng here?
    ... acTextBox Or ctrl.ControlType = acComboBox) Then _ ... (no e-mails, please!) ... For Each ctrl In Detail.Controls ...
    (microsoft.public.access.formscoding)