have a field in CAPS all the time

  • Thread starter Thread starter Anouska
  • Start date Start date
A

Anouska

Hi,

Is there a way in which I can make a certain field on a
form always typed in CAPS no matter what is actually
typed in. Alternatively, can I make a certain field
always caps when saved in the table?
 
Anouska,

If all you want is to *see* the form field in uppercase, then set the
control's Format property to > (greater than).

If you actually want to *store* it as uppercase, then in the control's
AfterUpdate event, add the following code:
Me!txtMyTextBox = UCase(Me!txtMyTextBox)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top