I have a report on which I added Print Preview command button. The On-Click event of the button contains the following code only:
DoCmd.RunCommand acCmdPrintPreview
When the Print Preview is clicked the preview opens as expected but the entire application seems to freeze and Access does not...
I must be a real dim bulb because every iteration I have tried comes out looking something like this:
"M-"####"- + D"a"teP"a"rt(yy",\Da"te())" or variations of same.
All the extra quotes and |'s are added by Access when I exit the field.
What am I missing?
I can see now that my post was not entirely clear, sorry about that. I want the mask to enter the current year, no matter what year it is, not just this current year of '08.
I'm trying to build an input mask that allows the user to enter a 4 digit number and the mask will format it as follows:
M-xxxx-08
Where the x's are the number entered by the user, the "M-" is pre-formatted and the "08" represents the current year, also pre-formatted.
So far I have been...
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.