Capitilize Dates in a report

N

norm

How does one capitilze the date in a report?
I am using Date() function in a report - but how do I force the date to
UPPER case?

Thanks!
 
K

Karsten Schultz

norm said:
How does one capitilze the date in a report?
I am using Date() function in a report - but how do I force the date to
UPPER case?

Thanks!
Click to expand...

You can use the UCASE-function of ACCESS.

Example: Control = ucase (format (Now()); "mmmm.dd.yyyy")

With friendly regards

Karsten
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Upper Case 2
access 2010 date field 3
Date Range in Reports 2
print a date range from parameter query on a report header? 2
Displaying date parameter on a multiple page report 3
Open filtered report 8
Uppercase 1st Letter 2
Show one report per customer if multiple sales 0

Top