Fields on Forms Wont Use Vb Capitalize Code

[burrina]

For some strange reason, all of a sudden, none of my fields on my forms wont capitalize.
Ex:
Field Name CustCompanyName


Code on After UpDate Event
CustCompanyName = StrConv(CustCompanyName, vbProperCase)

Why?
I turned OFF the AutoCorrect thing, no change.

[June7]

Something must have been changed. Can't replicate the issue. Would have to examine db.

[John_G]

Does the data you want to capitalize already exist on the form (i.e. in the table), and are you tabbing through the field?

If so, that is the problem - After Update does not fire unless you edit the field, i.e. type something in it.

Might that be the issue?

John

[June7]

The code in the AfterUpdate event should have saved the data with the propercase structure when the data was originally entered so tabbing through field should not be relevant unless this is not the form where that data is entered to table or the data has been imported.

[burrina]

Database Got Corrupt Somehow, somebody snuck in while I wasn't looking and did something. Copied into new db, all is well for now.

Thanks,