Capitalize

[DizzyD]

So here's my problem. We just installed VISTA onto our laptops. We use to have Mico Access '03 on XP and have updated to Mico Access '07 on Vista. I had my data base built so that everything capitalized once you entered the information. Now with this updated data base, it does not do it anymore. I was using the code:



Private Sub LName_AfterUpdate()
LName = StrConv(LName, vbUpperCase)
End Sub

Does anyone know how I can resolve this issue? Any help would be great! Thanks!

DD

[TheShabz]

What error are you getting?

Also, to prevent future problems, do yourself a favor and either go to win7 or back to winXP. Vista has been nothing but problems.

[DizzyD]

Well there is no error appearing. It's just not capitalizing the fields that use to capitalize after an update.

I completely agree about VISTA, but I'm in the military and I can't change the system back to XP. Simple fix for me would to ask if anyone knew how to correct this problem I'm having. Trust me I'm not excited about this new program! It has been nothing but problems and we've only had it for two days!

ARMY STRONG!

[Access_Blaster]

With out any code at all, open any table in design view, click on any field goto to the bottom window and in the "format" field place a greater then sign > That will cause uppercase. It also can be done in controls on forms reports and so on.



Richard