Hi,
I have a form with many textboxes that require user to fill in. Some textboxes are locked (which don't require user input) and some are unlocked (require user input).
I'm writing a macro that will:
1. display the unlocked textboxes in yellow to make it clearer to user that they are mandatory fields during form initialize.
2. Once the user has entered something in a textbox, that field then becomes white again.
I have managed to do (1) but not (2). I suppose I can repeat the same code for each textbox's Exit event, but is there a better way?
Thank you.
I have a form with many textboxes that require user to fill in. Some textboxes are locked (which don't require user input) and some are unlocked (require user input).
I'm writing a macro that will:
1. display the unlocked textboxes in yellow to make it clearer to user that they are mandatory fields during form initialize.
2. Once the user has entered something in a textbox, that field then becomes white again.
I have managed to do (1) but not (2). I suppose I can repeat the same code for each textbox's Exit event, but is there a better way?
Thank you.
