microsoft access courses - MS Access - event procedure & format of .... Now()

The UK's most regular instructor-led training courses.
Training information: microsoft access courses · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

MS Access - event procedure & format of .... Now()

Frances has attended:
Access Introduction course
Access Intermediate course

by - delegate Frances [8 posts] (2007 Aug 16 Thu, 11:33) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	5	book now	£198	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: MS Access - event procedure & format of .... Now()

by - trainer Pete platinum contributer [799 posts] (2007 Sep 7 Fri, 13:26) Reply

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.

· How to Find a Third-Party Venue for Microsoft Access Training
· Why a Microsoft Access Course Could Change the Way You Do Business
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Tips for designing databases in Microsoft Access

Access tip:

Remove spaces in a table

If 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

View all Access hints and tips