Caps

[ladyrider696]

I want a field to be uppercase when data is being typed. But when I run the report the data shows up as lower case.

 

[ladyrider696]

Uppercase in a field

I put a > in the input mask for a field, but when I run the report the data shows up as it is typed upper or lowercase. What do I put in the input mask to make the data uppercase to show not only in the datasheet and form but also in the report?

 

[Ghoztrider]

It's funny you ask that. My textbook I'm working with in Access has a solution just for that. It requires a module so I'm not sure if that's what you want. Anyway here is the code for the module.

Function CapAll(FValue)
CapAll = UCase(FValue)
End Function

Hope this helps!

 

[boblarson]

You can either store the data as upper case or you can just set them in the format of whatever data you want displayed that way. And to do it all it takes is to put this:

>

in the format of the text box for the report.

If you want it stored as all caps, then instead of using an extra function, just put this in the control's BEFORE UPDATE event:

Me.YourControlNameHere = UCase(Me.YourControlNameHere)

 

[ladyrider696]

Where would I put

Function CapAll(FValue)
CapAll = UCase(FValue)
End Function

I am working in table and form design.

 

[boblarson]

Where would I put

Function CapAll(FValue)
CapAll = UCase(FValue)
End Function

I am working in table and form design.

You do not need that function. Read my post after Ghoztrider's.

 

[John Big Booty]

Re: Uppercase in a field

The ">" only effects how the text is viewed not how the text is stored.

Have a look at the UCase() function, I believe that this function will force text to be stored in upper case.

 

[boblarson]

Re: Uppercase in a field

And don't post essentially duplicate posts (you posted this only minutes after the other one (which I am merging together).

 

[John Big Booty]

A double post