Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· Growing A Customer Base For A New Business - With The Help Of Access
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Enhancing The Customer Experience With Access
· Find Microsoft Access Templates For Any Task

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips