First Letter of Word to upper case

[access2010]

We have tried to have the word in the field, Transaction, start with a Capital, without success.
We have also tried to have the contact name start with a capital, Bill Smith
>
>L<????????????????????????
><??????????????????
>?<???????????????????

Your suggestion on how to correct our problem will be appreciated

Thank you,
Nicole

 

[theDBguy]

Hi. Are you talking about an Input Mask or Formatting? Or maybe, are you trying to update existing data?

 

[Gasman]

Deja Vu perhaps?

Input masks not working

Hello, I have tried the following input masks in Access 2003, and they are not working. Could I please receive a suggestion on how to correct this problem? === Entered as = BILL SMITH or bill smith >L

www.access-programmers.co.uk

 

[smtazulislam]

Try it...

Private Sub txtContactName_AfterUpdate()
    'For Proper Case
    Me.txtContactName = StrConv(Me.txtContactName, vbProperCase)
End Sub

 

[access2010]

Hi. Are you talking about an Input Mask or Formatting? Or maybe, are you trying to update existing data?

Thank you for your note.
We would like to use the Upper Case formatting for new data.
Thank you,
Crystal

 

[theDBguy]

Thank you for your note.
We would like to use the Upper Case formatting for new data.
Thank you,
Crystal

That sounds like an Input Mask then. Try the following in the Input Mask property.

>L<??????????????

Hope that helps...

 

[access2010]

Thank you for your suggestion, and the results are shown below

 

[theDBguy]

Thank you for your suggestion, and the results are shown below
View attachment 84183

What is the data type of your field?

 

[arnelgp]

use the Change event of your textbox:

Private Sub textbox1_Change()
    Me.textbox1.Text = UCase(Me.textbox1.Text & "")
End Sub

 

[access2010]

What is the data type of your field?

The data type is = Text =

 

[theDBguy]

The data type is = Text =

Hmm, are you sure you put it in the Input Mask property?

 

[access2010]

use the Change event of your textbox:

Private Sub textbox1_Change()
    Me.textbox1.Text = UCase(Me.textbox1.Text & "")
End Sub

===
Thank you for your suggestion, arnelgp, but we receive a compile error in Access 2003.
Nicole

 

[theDBguy]

Thank you for your suggestion, and the results are shown below

Hi. Since you are using numbers, try using this Input Mask.

>A<aaaaaaaaa

 

[Pat Hartman]

Just FYI, Input masks do not change data. They only affect how it is displayed so if you want to actually insure that the first letter is upper case when it is stored, you have to use one of the methods suggested above.

You didn't say what the compile error was but I would use the AfterUpdate event in any case rather than the Change event. The Change event runs multiple times. Once for each character typed but the AfterUpdate event runs only once.

Private Sub textbox1_Afterupdate()
    Me.textbox1 = UCase(Left(Me.textbox1, 1) & Mid(me.textbox1, 2)
End Sub

 

[theDBguy]

Just FYI, Input masks do not change data. They only affect how it is displayed...

Hi @Pat Hartman. I just gave it a try and got a different result

I created a table with two fields, an Autonumber and a Text field. I entered one record as "a." Went to table design and added an Input Mask of >L.

When I went back to Table View, the first record I entered earlier appeared as "A" now. I then entered a second record as "a" again. This, of course, immediately changed to "A" for me.

Then, I went to the Immediate Window and got the following results.

?dlookup("f1","Table1","id=1")
a
?dlookup("f1","Table1","id=2")
A

 

[Dreamweaver]

Why not use a propercase function there are a number posted.

make the first letter uppercase

i would like to start making my database a little more prettier especially in the customers table. i want to make the first letter of every name etc uppercase. my staff and me are quite inconsistant so to make it easier to read and present a little better i want the formating to all be the...

www.access-programmers.co.uk

 

[onur_can]

Can you pass the compilation error?

 

[Gasman]

Why not use a propercase function there are a number posted.

make the first letter uppercase

i would like to start making my database a little more prettier especially in the customers table. i want to make the first letter of every name etc uppercase. my staff and me are quite inconsistant so to make it easier to read and present a little better i want the formating to all be the...

www.access-programmers.co.uk

Mick,
This was asked by Access2010 (perhaps not the same person though) last December and they had a solution at the end of it all.
Now they are asking the same thing again?

 

[arnelgp]

Thank you for your suggestion, arnelgp, but we receive a compile error in Access 2003.

you need to replace textbox1 with the Correct textbox name.

 

[access2010]

use the Change event of your textbox:

Private Sub textbox1_Change()
    Me.textbox1.Text = UCase(Me.textbox1.Text & "")
End Sub

===
Thank you for your suggestion, but we have had no success.
Could you please look at the attached database and advise use what we have done wrong?

Thank you Nicole