Access 2007 Textbox Date Formatting

Question

I converted an older Access app to 2007, and now the date formatting in editable textboxes is not working. The format I'm using is mm/dd/yy, but the date is displaying with a 4-digit year.

I've tried other formats just for testing, eg mmm/d/yy - they display correctly except for the year which insists on being 4 digits.

This appears to be a new 'wrinkle' in A2007 - has anyone found a way around this?

Answer 1

I see something different on my system. With an ACCDB format database and a textbox format set to mm/dd/yy, today's date displays as 10/03/10.

It appears that if the checkbox for "Use four-digit year formatting" for "This database" is checked, Access uses 4 digits for the year regardless of the control's format property. To find that setting, click the Office Button, then Access Options -> Advanced and scroll down to the General heading.