Form Entry

  • Thread starter Thread starter Guest
  • Start date Start date
if you want the data to be *displayed* in all uppercase, set the Format
property of each appropriate control in the form toyou can select all the appropriate controls together, and then set the
property once and it will change all of the selected controls - quicker than
one-by-one.

if you want the data to be *saved to the underlying table* as all uppercase,
add the following code to each control's AfterUpdate event procedure, as

Screen.ActiveControl = UCase(Screen.ActiveControl)

hth
 
Back
Top