Upper Case month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich Stone - 18 Mar 2007 18:18 GMT

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?

Reply to this Message

Rich Stone - 18 Mar 2007 18:30 GMT

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

Reply to this Message

fredg - 18 Mar 2007 18:39 GMT

> 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
[quoted text clipped - 3 lines]
>
> Can anyone help?

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Rich Stone - 18 Mar 2007 20:14 GMT

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
[quoted text clipped - 7 lines]
> Set it's control source to:
> =UCase(Format([DateField],"mmm-yy"))

Reply to this Message