If you want this to happen immediately, you need to write a client-side
onKeyPress event for the textbox element in question.  You would use the
String object's toUpper() method.  If you want to do this in .NET, you need
to wait until the user submits the data and in the page's postback event
handler use:  Textbox.Text = Textbox.Text.ToUpper().

Instead of using RequiredFieldValidator controls for the Add Record fields,
use CustomValidator controls.  In the Click event handler for the Add Record
button, set a Boolean flag to True.  In your custom validator code, do your
validation for non-null values only if the Boolean flag is True.