I have this string in the input mask of a field "99/99/00;0;_". I want to have the format be 5/21/05 but it keeps showing up as 5/21/2005. I have tried "9/99/00;;_" as well with the same results. What am I doing wrong?? Thanks for your help
This is the format from the input mask in the properties box. I have even tried to edit the existing formats--shows that it works in the example but then does not work when I use it in the form. Is there an over riding format for the entire program that is forcing it to default to this. You mention "general date rather than dd/mm/yy"--what is "general date". thanks again
The Input Mask is how the user is asked to enter data, the Format is how the data will be displayed. Both the field in the table and the control on the form have a format property. Short Date and Long date are taken from the Regional and Language Setting (XP) in the control panel. As far as I recall, Access defaults to short date format, unless you say different by, say, specifying dd/mm/yy, or, in your case, mm/dd/yy as the format (unless that is the short date that you have set in the control panel). General Date is Short Date with Time tacked on.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.