Changing the back ground colour of a control if the value is null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to highlight fields that have null values (blank) in red.

i have tried using the following code but it does nothing.
Private Sub Form_Load()

If [Form_missing_nom_data_qry].[Agents_Name] = IsNull Then _
[Form_missing_nom_data_frm].[Agents_Name].BackColor (255)
End If

End Sub

could somebody please tell me where i am going wrong.

Cheers
 
try the test like this

if isnull([Form_missing_nom_data_qry].[Agents_Name]) then
[Form_missing_nom_data_frm].[Agents_Name].BackColor = 255
endif


You may also look into the conditional format aspect of the control.
rightclick on the control and select "conditional format"

Ron
 
Thanks Ron,

I have tried the method sugested below but have had no luck. have also tried
the conditional formating, but cannot get that to work either.
 
Any further help will be apreciated.

Apples76 said:
Thanks Ron,

I have tried the method sugested below but have had no luck. have also tried
the conditional formating, but cannot get that to work either.


Ron2006 said:
try the test like this

if isnull([Form_missing_nom_data_qry].[Agents_Name]) then
[Form_missing_nom_data_frm].[Agents_Name].BackColor = 255
endif


You may also look into the conditional format aspect of the control.
rightclick on the control and select "conditional format"

Ron
Click to expand...
Click to expand...
 
have you tried the isnull(me.fieldname) instead of the longer form.?

Also I have sometimes found some fields that responded to "" instead of
isnull.
The test would then be: if me.fieldname = "" then

I can't see the full message right now, but you might try the code in
the ONCurrent event.

Ron
 
Back
Top