WH> To explain, instead of having the person shift on capitalization, I
 WH> would like to allow them to enter the data straight through and have
 WH> Access capitalize automatically.
Hi Will,
In the AfterUpdate property of each control that you want to force to 
Caps put this line:
     [ControlName] = UCase$([ControlName])
That should do the trick... 
   ô  All my BEST, Don, W5MML  ô  InterNet: sysop@camellot.usbbs.com       ô
   õ     Jeddah, Saudi Arabia  õ  Fido: 2:542/700 AKA: 9:500/91 239:105/30 õ 
 * 1st 2.00 #281 * To poldly bow air mobius gumby four: Star Trek on 
novocaine.
--- PCBoard (R) v15.3/2
---------------