StrConv Init cap with exclude

[DK22]

Hello,

Im linking to sql across ms access and I have all records uppercase.

I need to set StrConv with first character uppercase and every other lowercase which is not problem.

But I also need an exclude in this function to skip some words which I need to leave uppercase.

Any ideas?

 

[bob fitz]

Hello,

Im linking to sql across ms access and I have all records uppercase.

I need to set StrConv with first character uppercase and every other lowercase which is not problem.

But I also need an exclude in this function to skip some words which I need to leave uppercase.

Any ideas?

Which words need to remain in upper case

 

[DK22]

Which words need to remain in upper case

Products manufacturers, I have about 50 words in total.

 

[bob fitz]

Products manufacturers, I have about 50 words in total.

Are they in a table of Manufacturers.

 

[DK22]

Are they in a table of Manufacturers.

nope, they are contained in a name of products.

For example:

I have:
MENS SHOES NIKE AIR MAX

With StrConv I can make:
Mens shoes nike air max

But I need this:
Mens shoes NIKE air max

 

[bob fitz]

If you had a table of the names then you could create a function to loop through the table and the string using Replace() function, but I can't think of any other way.