After Update - Change Case in Microsoft Access


	Back to Change Case Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

After Update

Dan Jackson

4 years ago

Hey,

This is cool. I've followed the Ext Cut to create the Global but would like the field to update automatically upon entry instead of having to run an update query.

I notice you have the AfterUpdate link which is what i want to use but its very generic. How would i apply AfterUpdate to this scenario?

I'm assuming I set up the proper case field in the query but instead of displaying it on the form, i use the AfterUpdate to replace the value in "Surname" with the value in "MPC"

so

- Enter bad name in surname field on form: jackson
- MPC field in the query converts to Jackson
- The AfterUpdate Event replaces the entry in surname with the data in "MPC" field.

How do i do step 3? Many thanks

	Adam Schwanz @Reply 4 years ago
You can just do this in the after update FieldName = StrConv(FieldName, vbProperCase)

	Adam Schwanz @Reply 4 years ago
I haven't seen the video in ages but it appears if you want to use the MPC all you would need to do is FieldName = MyProperCase(FieldName)

	Scott Axton @Reply 4 years ago
Dan to do it on the fly - not in the query you would just have to do the same thing it the AfterUpdate of each field you want it to work with. YourField = MyProperCase(YourField) `FirstName = MyProperCase(FirstName)`

	Dan Jackson OP @Reply 4 years ago
Cool, works a treat, thanks. Glad i can do it on the fly rather than through a query - much better. Got an issue with handling of null values but posted that as a question earlier so will see how it goes. Thanks again

	Dan Jackson OP @Reply 4 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Change Case.

Next Unseen

New Feature: Comment Live View