Code for Default text Value, Help?

[Kroghr]

I have a bound field on a reprot named "ON". The field is formated for Short Time. Whenever there is no ON Time. I would like the field to display the text Originate. I've tried

If Me!On = null Then
Me.On = Originate
End if

Does not work.

I've also tried to set the default value as Originate, but i get an error which i belive becsue the field is formated for time, not text.

Conditional formating has not worked for me either

Any sugesstions?

 

[boblarson]

Instead of binding it to the field, set the text box's control source to

=IIf(IsNull([On]),"Originate",Format([On],"h:n"))