[AccessD] Access date-time format

You can use an input mask on the field in your form which would be...

00->L<LL-00-99:00 >LL 

 
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 



----- Original Message ----
From: Arthur Fuller <fuller.artful at gmail.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Wednesday, August 29, 2007 4:31:59 AM
Subject: [AccessD] Access date-time format


Is there a format string that one can use to combine date and time format,
to guide the user? I want to combine medium date format and medium time
format into one format for the whole field but I can't seem to get it right.

I want the formatted data to look like this:

30-Sep-07 5:30 PM

It seems silly to use two fields to achieve this but I can't get the correct
format string to just use one.

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


       
____________________________________________________________________________________
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. 
http://mobile.yahoo.com/go?refer=1GNXIC