98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - MS Access - event procedure & format of .... Now() | Access forum
microsoft access courses - MS Access - event procedure & format of .... Now() | Access forum
Resolved · Low Priority · Version Standard
Thu 16 Aug 2007, 11:33Delegate Frances said...
Frances has attended:
Access Introduction course
Access Intermediate course
MS Access - event procedure & format of .... Now()
Hi there,
I've used a 'Me.MODIFIED=Now()' event procedure (and =Now() at the text box level) but I want the format of the date output to be yyyy-mm-dd... can you tell me how I can achieve this...?
I've tried input mas !0000\-00\-00;0;" " at the text box level and this does not work.
thanks
Frances
Fri 7 Sep 2007, 13:26Trainer Pete said...
RE: MS Access - event procedure & format of .... Now()
Hello Frances,
I have had a try at your problem, and feel that if you create a field for the date rather than a text box for your =now() event, in the default value option enter your =now() and then change the format value to yyyy mm dd. You should find that that works. Hope this sorts your problem.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
