Modify Field Forecolor

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

Guest

Does anyone know how to Modify a fields forecolor. Not the simple change everything, I have a particular field on a form. I have many record on this form and want to know how to tell one field then if another field ( a date field ) that if there is no date in this field to change the value to red. I can't figure this out. I've seen it done but I can't figure out the coding. If anyone has any idea please let me know. I can get it to change red, however every record turns red, even the ones with date in that other feild.

Thanks,

Thomas
 
Try putting in the Form_Currrent event something on the lines of-
if IsNull(Me.DateControl) then
Me.DateControl.ForeColor = vbRed
else
Me.DateControl.Forecolor=Other Colour
endif

and the same in the DateControl_AfterUpdate event

Nakirema said:
Does anyone know how to Modify a fields forecolor. Not the simple change
Click to expand...
everything, I have a particular field on a form. I have many record on this
form and want to know how to tell one field then if another field ( a date
field ) that if there is no date in this field to change the value to red.
I can't figure this out. I've seen it done but I can't figure out the
coding. If anyone has any idea please let me know. I can get it to change
red, however every record turns red, even the ones with date in that other
feild.
 
Back
Top