Exporting query -- uppercase data

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

Guest

When I export a query, I want one of my fields to be exported in
uppercase. I've used the ">" criteria in the format and input mask fields for
my table. The field appears in uppercase when I view the query, but when it's
exported, some of the data is lowercase.
 
You're confusing two different functions. ">" meaning UPPER CASE is only a
display option; it doesn't change the actual data. If you want the data to
actually change to upper case, use the UCase() function, as in txtUpperCase:
UCase(txtMixedCase).
 
That's helpful, but isn't there anyway to force my data in a table to be
uppercase besides running a function on all the data? I don't want to have to
think about taking that extra step. I just want the data in that field to
always be upper case.
 
Sorry, there isn't.

The only other way is to use the UCase() function when you first put the data
in the table. Obviously, that's the same as using the function when you
report on it. Six of one and half-a-dozen of the other.
That's helpful, but isn't there anyway to force my data in a table to be
uppercase besides running a function on all the data? I don't want to have to
think about taking that extra step. I just want the data in that field to
always be upper case.
You're confusing two different functions. ">" meaning UPPER CASE is only a
display option; it doesn't change the actual data. If you want the data to
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Back
Top