Go to Top

Gain more space in your reports – Use a new date format

Dates on reports can be a pain, you have to leave enough space for the worst case scenario, usually 12/12/xxxx, if you have a lot of date columns all that space can add up. Instead of using Short Date in the format field of the report’s format tab, use mm/dd/yy instead. It will guarantee all months and years are two digits and you can space your columns accordingly.

By the way, you can use mm, dd and yy in other combinations too:

MS Access Report Generator

dd/mm/yy – Used in Latin America
mm/yyyy – Month/Year

Start saving some trees today and use the reduced format!

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

2 Responses to "Gain more space in your reports – Use a new date format"

  • Susie
    October 5, 2015 - 1:39 am Reply

    I realized my last comment was a bit hasty. I assume later versions of Access now have mmddyy as formats we can choose. But I’m using Access 2010 and that format is not available, so I was looking for instructions on how to do it myself.

    I think your post has to start with “Starting with xyz version of Access, you can now choose MMDDYY as a date format.”

  • Susie
    October 5, 2015 - 1:36 am Reply

    So, it’s great that you told me to use this format, but you didn’t tell me how to do it. Not really helpful.

Leave a Reply

Your email address will not be published. Required fields are marked *


Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.