Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - MS Access - event procedure & format of .... Now()

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

ResolvedVersion Standard

Thu 16 Aug 2007, 11:33 Delegate 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:26 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

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

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

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

Access articles

Access tip:

Hiding Multiple Table columns