Form Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have all data entered into the form appear in UPPERCASE.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Uppercase only fix and prevent 7
forcing uppercase 2
Access Automatically Send a notification email once a record is added 0
Data entry for a table from a form 2
Data Availability - Timing 6
User Sets Control Default Value 1
Creating Custom MS-Access Input Masks 0
Changing Case 2

Back
Top