Case sensitive Fields

[Guest]

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)

 

[Allen Browne]

Use the AfterUpdate event procedure of the text box where you enter this
data to convert the entry to upper case:

Me.[MyField] = UCase(Me.[MyField])

That's the only way to get it to upper case anyway.
Setting the Format property only affects how it is displayed.

 

[Arvin Meyer]

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

 

[Guest]

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

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

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)

 

[Allen Browne]

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

 

[Guest]

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

 

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

 

[Guest]

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.

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

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