Fixing Data

[AutyGraphMan]

Hello,

I want to fix data supplied to us and I have everything working up to capitalizing the first letter and getting the rest of the string to be lower case. I am using code originally written by Jay Holovacs.

For example, JOHN comes out John.

However, for company names that are 3 letters, eg: ATT, JBL, etc. I get Att and Jbl - but I want them to remain as 3 capital letters.

I want to create a lookup table that I can first find these 3 letters and then choose to add them to a dictionary for later use. Once in the dictionary, the program will simply leave them as caps.

I am new to VBA, although I am familiar with programming, I need some help getting started.

Thanks, Brian

 

[ghudson]

Check out r_cubed's sample for it has many routines dealing with Capitalization problems and conversions...

Capitalization routines (revisited - 2nd time round) sample.
You must be a member [it is free] of www.UtterAccess.com to download this sample.

 

[AutyGraphMan]

Update

Thanks for this.

 

[lution]

The URL pointed to in the previous post has changed:

http://www.utteraccess.com/forums/s...u=15840&Zd=l&Zn=&Zt=e&Zs=b&Zy=#Post619856&Zp=

Just in case someone else goes looking for it like I did.

 

[gemma-the-husky]

having said all this, by default access ignores any capitalization, so its only for presentation. It wont affect your dictionary whether letters are upper or lower case