Exporting query -- uppercase data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BrianS - 15 Nov 2005 19:46 GMT

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.

Reply to this Message

OfficeDev18 - 15 Nov 2005 19:58 GMT

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).

>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.

Signature

Sam

Reply to this Message

BrianS - 15 Nov 2005 20:18 GMT

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
[quoted text clipped - 5 lines]
> >my table. The field appears in uppercase when I view the query, but when it's
> >exported, some of the data is lowercase.

Reply to this Message

OfficeDev18 - 16 Nov 2005 17:22 GMT

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
[quoted text clipped - 6 lines]
>> >my table. The field appears in uppercase when I view the query, but when it's
>> >exported, some of the data is lowercase.

Signature

Sam

Reply to this Message