ALL CAPS AGAIN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

You have all been very helpful and I really appreciate it. I learned alot
today. THis is what fanally did the trick in the Update Query:

UPDATE [MyTable] SET [MyTable]!MyField = StrConv([MyTable]!MyField,3);

There is one more thing though. I have one field for the address that has
numbers and letters. It doesn't seem to want to work. Any ideas??
 
There is one more thing though. I have one field for the address that has
numbers and letters. It doesn't seem to want to work. Any ideas??
Click to expand...

In what way does it "not work"? Could you give an example of the data,
and the actual SQL of your query?

John W. Vinson[MVP]
 
It works fine for me.

?StrConv("1600 PENNSYLVANIA avenue", 3)
1600 Pennsylvania Avenue

What happens when you try?
 
Sorry. It did work when I tried again. the column was named Address 1. It
worked when I change dthe column name to Adress1. Picky isn't it? Thank
you both for your help.
 
Sorry. It did work when I tried again. the column was named Address 1. It
worked when I change dthe column name to Adress1. Picky isn't it?
Click to expand...

Computers are very fast idiots. They have NO understanding of what you
mean - just literally what you *say*!

The text strings "Address 1" and "Address1" are two different text
strings. A human might see them as "the same" but as you say,
computers are picky!

John W. Vinson[MVP]
 
Back
Top