Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2011, 04:02 PM
Andy2011 Andy2011 is offline Day and Month to Uppercase Windows Vista Day and Month to Uppercase Office 2007
Novice
Day and Month to Uppercase
 
Join Date: Jul 2011
Posts: 9
Andy2011 is on a distinguished road
Default Day and Month to Uppercase

Can anyone tell me how I can change DAY and MONTH names within a TextBox to Uppercase. I have discovered code that will change the TextBox entry to Sentence Case...but how do you do this?
Reply With Quote
  #2  
Old 07-22-2011, 04:34 PM
macropod's Avatar
macropod macropod is offline Day and Month to Uppercase Windows 7 64bit Day and Month to Uppercase Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Andy,

Try something along the lines of:
TextBox1.Text = UCase(Format(Now(), "DDDD, D MMMM YYYY"))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
start-stop month dates in calendar madison320 Project 0 06-24-2011 08:15 AM
Day and Month to Uppercase Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM
Can't see delegates calendar past next month. enviroko Outlook 3 08-08-2010 01:10 PM
How to archive each month and automatically add the date to end of archive name. Phipps Outlook 0 03-11-2009 05:36 PM
Displaying work week in month view tupham Outlook 0 10-28-2008 02:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft