[AccessD] YYYY/MM/DD format in Access

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





More information about the AccessD mailing list