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:
dd/mm/yy – Used in Latin America
mm/yyyy – Month/Year
Start saving some trees today and use the reduced format!
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
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.”
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.