User Defined Date

[momoko]

Hi,

is there a way to make the date all in caps, I'm using in the format
dd-mmm-yyyy. This give me for example 30-Jul-2002 but I would like it in 30-JUL-2002.

Tks,

 

[DBL]

In the Format property of the field put

>

You can either do that in the table or the form.

Another way would be to change the field to uppercase as the user updates the field. On the AfterUpdate event of the date field put the following in the event procedure:

Me.DateFieldName = UCase (Me.DateFieldName)

 

[gear]

I have a Date field which gives date as 02-Apr-2007. How can I change it to appear in this format dd-mm-yyyy i.e. 03-04-2007? This format is not available in the access default settings. Any ideas ?

 

[boblarson]

just type "dd-mm-yyyy" in the format and don't select one from the drop down.

 

[gear]

Thank you Sir, I have done it.