Allow Caps Only in Text Fields

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

We do mass mailings and when we send our prospect list to our printing
company they require that our exported text file is in capital letters only.
How can I make it so people can only enter a new address in capital letters?
 
We do mass mailings and when we send our prospect list to our printing
company they require that our exported text file is in capital letters only.
How can I make it so people can only enter a new address in capital letters?
Click to expand...

I'd suggest fixing the entry after it's added - either in the process of
putting the data in the field, or in the export process.

To fix it as users enter the data, use a Form for data entry (users should not
be working directly in tables); in the AfterUpdate event of each textbox that
needs to be in all caps put code like

Private Sub textboxname_AfterUpdate()
Me!textboxname = UCase(Me!textboxname)
End Sub


Personally I'd rather leave the data as entered (I don't like all caps, IT'S
HARD TO READ AND LOOKS LIKE SHOUTING) and do it in the export process; rather
than exporting from the table directly, use a Query with a calculated field

ExpFieldname: UCase([fieldname])

for each such field.
 
John W. Vinson said:
We do mass mailings and when we send our prospect list to our printing
company they require that our exported text file is in capital letters only.
How can I make it so people can only enter a new address in capital letters?
Click to expand...

I'd suggest fixing the entry after it's added - either in the process of
putting the data in the field, or in the export process.

To fix it as users enter the data, use a Form for data entry (users should not
be working directly in tables); in the AfterUpdate event of each textbox that
needs to be in all caps put code like

Private Sub textboxname_AfterUpdate()
Me!textboxname = UCase(Me!textboxname)
End Sub


Personally I'd rather leave the data as entered (I don't like all caps, IT'S
HARD TO READ AND LOOKS LIKE SHOUTING) and do it in the export process; rather
than exporting from the table directly, use a Query with a calculated field

ExpFieldname: UCase([fieldname])

for each such field.
--

John W. Vinson [MVP]
.
The Code worked Perfect! Of course you already knew that but it was exactly what I was looking for. Thanks so much!
Click to expand...
 
Back
Top