Bobby Heid
bheid at sc.rr.com
Sun Jan 4 11:49:26 CST 2009
Oh, I think you would just set the format on the text box to yyyy/mm/dd. I do not think it needs quotes. Thanks, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Sunday, January 04, 2009 12:33 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] YYYY/MM/DD format in Access That prints the date as I wish but I can't figure out how to use that expression in a bound form. Maybe I should be using unbound field and then writing its contents to the real field? Hmmm. Arthur On Sun, Jan 4, 2009 at 11:48 AM, Bobby Heid <bheid at sc.rr.com> wrote: > Are you asking about something as simple as > format$([somedate],"yyyy/mm/dd")? > > Bobby > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com