Upper Case month

[Guest]

I wish to set a default for a text box based on the current month and year
but I wish the month to be in UPPER case, for example MAY-07. I can get the
date but can't get the month to be upper case. When I try and force this in
the format property, it changes the mmm-yy to be in quotes and literally
shows mmm-yy, then the date code.

Can anyone help?

 

[Guest]

Just to add, the box must be editable...

 

[fredg]

I wish to set a default for a text box based on the current month and year
but I wish the month to be in UPPER case, for example MAY-07. I can get the
date but can't get the month to be upper case. When I try and force this in
the format property, it changes the mmm-yy to be in quotes and literally
shows mmm-yy, then the date code.

Can anyone help?

Use an unbound control.
Set it's control source to:
=UCase(Format([DateField],"mmm-yy"))

 

[Guest]

Thanks Fred, worked a treat!

I wish to set a default for a text box based on the current month and year
but I wish the month to be in UPPER case, for example MAY-07. I can get the
date but can't get the month to be upper case. When I try and force this in
the format property, it changes the mmm-yy to be in quotes and literally
shows mmm-yy, then the date code.

Can anyone help?

Use an unbound control.
Set it's control source to:
=UCase(Format([DateField],"mmm-yy"))