Can the first letter in the field automatically be capitalized?

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

Guest

When entering data into a field, can I set up a field to automatically
capitalize the first letter for me?
 
In the text box's AfterUpdate eventHandler, put in code along the lines of
txtMyField = UCase(Left(txtMyField,1)) & Mid(txtMyField,2)
where txtMyField is the name of the text box.

Hope This Helps
Gerald Stanley MCSD
 
Hi Gerald,

Thanks for your suggestion. I am not familar with "AfterUpdate
eventHandler". Is this found under properties?
TLong
 
I think the answer might be in the input mask used on that field. Check the
HELP screen for that property and I think you'll find what's needed....
Bob.
 
Hi Gerald,

Thanks for your suggestion. I am not familar with "AfterUpdate
eventHandler". Is this found under properties?
TLong
Click to expand...

In design view, display the control's property sheet.
Click on the Events tab.
On the line that says After update, write
[Event Procedure]
Then click on the button with the 3 dots that appears on that line.
When the AfterUpdate code window opens, the cursor will be flashing
between 2 already written lines of code.
Between those 2 lines, write

txtMyField = UCase(Left(txtMyField,1)) & Mid(txtMyField,2)

Change txtMyField to whatever the actual Name of that control is.
Exit.
 
Back
Top