G Gloria Dec 30, 2008 #1 How do I put an indicator in a field so that if text is entered in lower case it will automatically change to upper case. Thank you.
How do I put an indicator in a field so that if text is entered in lower case it will automatically change to upper case. Thank you.
J John W. Vinson Dec 30, 2008 #2 How do I put an indicator in a field so that if text is entered in lower case it will automatically change to upper case. Thank you. Click to expand... There's no "indicator" to do so. You can set the Format property of a form or report control to Just the single right-corner-bracket character, to *display* the contents in upper case regardless of how they're stored; or you can run an update query updating the field to UCase([fieldname]) to update existing data; or you can put some VBA code in the AfterUpdate event of the textbox on a Form to convert the data to upper case.
How do I put an indicator in a field so that if text is entered in lower case it will automatically change to upper case. Thank you. Click to expand... There's no "indicator" to do so. You can set the Format property of a form or report control to Just the single right-corner-bracket character, to *display* the contents in upper case regardless of how they're stored; or you can run an update query updating the field to UCase([fieldname]) to update existing data; or you can put some VBA code in the AfterUpdate event of the textbox on a Form to convert the data to upper case.
