Title Case (2000 sp3)

Topic

New Reply

Is there a way (in Reports especially but maybe forms as well) to change existing text to the equivalent of Title Case

Reply | Quote

Replies

You can use the StrConv function to convert text to a different case.

In the query behind the form or report create a calculated field as below

PCName : StrConv([Name],3)

The second parameter (in this case 3 = propercase ) indicates the type of conversion. Look up VBA help to see a list of different allowble values.

Reply | Quote

You can use the StrConv function to convert text to a different case.

In the query behind the form or report create a calculated field as below

PCName : StrConv([Name],3)

The second parameter (in this case 3 = propercase ) indicates the type of conversion. Look up VBA help to see a list of different allowble values.

Reply | Quote