Capitalizing Case in Validation Rule in Table

Topic

New Reply

Is it possible to add the following expression in the Validation Rule in a table?
=StrConv(FirstName, vbProperCase)

Thanks.
Armstrong

Reply | Quote

Replies

That won’t work, for the expression in the Validation Rule must evaluate to True or False. Your expression returns a string.

If you want to convert a field to proper case, you must do so in the After Update event of the text box bound to the field on the data entry form, or in the Before Update event of the form as a whole.

Reply | Quote

That won’t work, for the expression in the Validation Rule must evaluate to True or False. Your expression returns a string.

If you want to convert a field to proper case, you must do so in the After Update event of the text box bound to the field on the data entry form, or in the Before Update event of the form as a whole.

Hi Hans,
Thanks for your suggestion. However, your solution requires a form, which I wish to avoid if possible. That’s why I ask whether the capitalization can be done thru the validation rule. Apparently, it’s impossible.
Armstrong

Reply | Quote

You can’t do such things in a table or query. But that’s not a problem, since end users should never work directly with tables or queries, only with forms and reports.

Reply | Quote

You can’t do such things in a table or query. But that’s not a problem, since end users should never work directly with tables or queries, only with forms and reports.

Thanks for your help.
Armstrong

Reply | Quote