Share via

Setting Month Text to Upper Case

Anonymous
2019-10-11T12:00:30+00:00

I'm using the following to set a label's caption to tomorrow's date:

Me!lblDay2.Caption = Format$(Date + 1, "ddd mmm dd")

I'd like to set the abbreviated month to upper case but I'm not having much luck.

I've tried 'DDD' but that didn't work.

Any ideas,

James

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Duane Hookom 26,825 Reputation points Volunteer Moderator
2019-10-11T13:02:39+00:00

Full code would be:

Me!lblDay2.Caption = UCase(Format(Date + 1, "ddd mmm dd"))

You don't need the $

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-10-11T15:18:24+00:00

    Worked great.

    Thanks loads,

    James

    Was this answer helpful?

    0 comments
  2. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2019-10-11T12:03:13+00:00

    Hi,
    You could just wrap your expression in UCase().

    =UCase(Format(...

    Was this answer helpful?

    0 comments