Access report date field showing 8 digits

[maxwell2323]

I have an Access 2003 application where the mdb is a front end and all tables link to SQL 2000 tables in the back end. I have been told that the reports I have created within the app (thru Access) have to have their date fields set up so that 1/1/2009 becomes 01/01/2009. No zeros can be dropped. I am trying to solve this hopefully in one of two ways. In the SQL table, even if I directly type in 01/01/2009, it turns to 1/1/2009 anyway. The datatype I have is datetime. Now I could change the datatype to nvarchar, and use VBA code to make sure that the date appears properly on the report – but this is not the option I am looking for, please don’t offer that, I already do too many code workarounds. Is there some sort of mask I can apply to the SQL table, so that it forces anything to be entered into that table to have the 8 digit date and display as such? Or, is there a mask I can apply to the particular field on the bound text box of the design of the Access report? Which, by the way I tried (with 00/00/0000) and it still will not work – the report date still shows 1/1/2009. Please help.

 

[dhookom]

Have you tried setting the Format property to:
Format: mm/dd/yyyy

Duane
Hook'D on Access
MS Access MVP

 

[maxwell2323]

I think I tried that but I will try again and let you know