I'm currently working on an Access application which uses dates a lot. In my company we have the habit of using the following date format" yyww.d" being two digit year, two digit week and day of the week (example 20-feb-2004 => 0408.2)
In Access 97 you can set de format of a textfield to "yyww\.d" BUT this will give you a weeknumber in one or two digits (example 20-feb-2004 => 048.2) and that is could be read as Thuesday, week 48 in the year 2000... (differs a year or three ;-)
Because dates have to be entered in continues forms, manual programming is possible but not that straightforward. Anyone who can help?
Coding it in VBA isn't that much of a problem BUT that makes the textbox uneditable in the continues forms I'm using ;-)
At the moment I have the date encoded in the query behind the form (speed issue) and use a pop-up calendar to let people enter a date. Not very fancy but it works. Would be nice if it was possible to have a textbox that was bound to a date and uses the "yyww.d" format