How do I make each column UCase in a query

[Guest]

How do I make each column UCase in a query

 

[Marshall Barton]

How do I make each column UCase in a query

Not a good idea. If you must use upper case, do it in the
form/report that displays the query's records.

A custom format (in the Format property) ofwill display the value in upper case.

Note that formatting of any kind will truncate a Memo field
to 255 characters.

 

[John W. Vinson]

How do I make each column UCase in a query

SELECT UCase([thisfield]), UCase([thatfield]), UCase([theotherfield]) FROM
tablename;

or set the Format property of each field to > to display it in upper case.

Normally one would not make a query datasheet visible at all; instead you'ld
base a Form or Report on the query, and set the format property of each
textbox that you want capitalized to > in order to display the data in upper
case.

John W. Vinson [MVP]