=[AddressID] heading - can't hold UPPERCASE

[janine_docsonline]

I have a format of > to make uppercase for JONESJA, SMITHJB etc. But when I
try to put in form as heading it won't stay in UPPERCASE - what is available
to solve my problem?

Many tks whoever can would be much appreciated.

Regards

 

[Allen Browne]

The format character does not actually change the contents of the field -
just the way it is displayed.

To actually change the characters, use the AfterUpdate event procedure of
the text box where the entry is made to change it at the time of entry, or
use an Update query (Update on Query menu in query design view) to change
the existing records in your table.

This example converts the text in Text1:

Private Sub Text1_AfterUpdate()
Me.[Text1] = UCase(Me.[Text1])
End Sub