[AccessD] YYYY/MM/DD format in Access

Gustav Brock Gustav at cactus.dk
Sun Jan 4 11:44:17 CST 2009


Hi Arthur

Bind the TextBox to your date field.
Set the Format property of the TextBox to:

   yyyy/mm/dd

That's it.
The input mask, if you insist, could be: 

  9999/99/99

/gustav


>>> fuller.artful at gmail.com 04-01-2009 18:32 >>>
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





More information about the AccessD mailing list