How do I make each column UCase in a query

  • Thread starter Thread starter Guest
  • Start date Start date
ginabellamy said:
How do I make each column UCase in a query
Click to expand...


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.
 
How do I make each column UCase in a query
Click to expand...

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]
 
Back
Top