There is no "current.on load" event! There is a Form_Current event, and a Form_Load event (aka OnLoad); from your description of the problem, my guess is that you mean the latter, and like the Form_Activate event, is incorrect for this type of code!
Your Code should be in the AfterUpdate event of the Control that Status is entered in or selected from, depending on the type of Control it is, and also in the Form_Current event, which will assure that the formatting is Record-appropriate.
And hopefully this is a Single View Form, as this kind of formatting will not work in a Continuous View Form.
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007