change capitalization on existing table

[taylornow]

Hello everyone- I have inherited a database (1545 records) that everything is in capital letters. I am having a hard time getting it to capitalize just the first letter of each word in one column that has multiple words. Some of the names have a hyphen in them and some contain the number symbol (#) and then a number, etc. I can get just the first word changed but the others either don't change at all or the wrong letter goes lower case. Let's see ... how thick is my brain feeling right now ??? Very! Someone push me please.

Thanks in advance

Taylor

 

[taylornow]

Hey It's me again- Update on my question- I have changed them all in a SQL query -
SELECT strconv([District Name],3) AS District
FROM [Fire Department Survey List];

Is my best bet to just make table query the same way and start fresh ? If this should be in another forum - let me know.

Thanks in advance again.

Taylor

 

[Darrylles]

Hi,

First ensure that the data is in fact capitalised:

Goto the field in the table in design view and check the FORMAT property, if it has > in there then delete it because this DISPLAYS capitalised data.
If you had to do this, then view the data again, if not - no prob.

If not, then the simplest way is to replace field values dependant on the way they are currently built (some with #'s some with -'s etc) via subsequent queries.

Personally, I'd find it easier to produce a simple form that reads the data and writes it back via a VBA function.

If you're still having probs, then drop me a line (with examples of the different types of strings) and the table structure, and I'll send u a form that'll do it.

Regards

Darrylle



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."