All Caps

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

Guest

Is there a way to make sure that a string of data entered in a form (such as
"bbb") gets stored in the underlying table as "BBB"? I put the ">" in the
format field of the form but that doesn't do it.

Thanks

Kevin D
 
You could put something like this in the AfterUpdate event of all the fields
you want to be in upper case.

If Not IsNull(Me.LastName) Then Me.LastName= UCase(Me.LastName)
 
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

Subform on a Subform 3
create sheets from data 2
Do Until Loop help 1
Database and VBA 3
keep lover level bullet list with previous bullet 1
Report Question 3
max date based on criteria 2
Embedding a newline in strings 2

Back
Top