Case sensitive Fields

T

toolman74

I need to Set a field to all upper case. My problem is, I have mixed text and
numbers in the field. (>) will only allow me to type in text, (No Numbers)
 
B

bdehning

Arvin, What about this same situation on a report. I want to display November
1, 2004 as NOVEMBER 1, 2004?
Brian

Arvin Meyer said:
Use the AfterUpdate event of the textbox to change the text to upper case
like this (aircode):

Sub MyText_AfterUpdate()
MyText = UCase([MyText])
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

toolman74 said:
I need to Set a field to all upper case. My problem is, I have mixed text and
numbers in the field. (>) will only allow me to type in text, (No Numbers)
Click to expand...
Click to expand...
 
A

Allen Browne

Set the Control Source of the text box on the report to something like this:
=UCase(Format(Date(), "Long Date"))
 
B

bdehning

This may be dumb, but if my Control Source currently is Expiration Date, how
do I fit that with the code?
 
A

Allen Browne

=UCase(Format([Expiration Date], "Long Date"))

Make sure the Name of this text box is not Expiriation Date or any other
field name.
 
B

bdehning

Allen, worked great and I learned more about mm yy dd, etc where the long
date was.

Sorry it took so long to tell you thanks.

Allen Browne said:
=UCase(Format([Expiration Date], "Long Date"))

Make sure the Name of this text box is not Expiriation Date or any other
field name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

bdehning said:
This may be dumb, but if my Control Source currently is Expiration Date,
how
do I fit that with the code?
Click to expand...
Click to expand...
 
Top