Re: Date input mask.

chipshop <ejgn@*remove*gmx.net> wrote in
news:dk2t3f$e9p$1@xxxxxxxxxxxxxxxxxxx:

> Greetings all...
>
> I need to be able to input dates into a table in the following
> format:
>
> Saturday/29/October/2005
>
> Could someone please tell me the input mask for this?

NO!!!!!

Dates are stored in the tables as a double precision number.

You want instead to FORMAT the appearance of the date, after it has
been entered.

Put this in the format property of the textbox or field
dddd\/dd\/mmmm\/yyyy
--
Bob Quintal

PA is y I've altered my email address.
.

Relevant Pages

  • Re: Small textbox width forces rounding.
    ... Sounds as if the format property for the textbox may be incorrect. ... Candia Computer Consulting - Candia NH ...
    (microsoft.public.access.forms)
  • Re: Conditional Format Using AND
    ... but I only want the color change to happen if "PREV" is in column A, ... > your second format condition will always be true and red format ... > Pearson Software Consulting, LLC ...
    (microsoft.public.excel.misc)
  • Re: Change number to extensive week day
    ... Assuming you mean you want to know the day in text, simply use the Format ... Formatwill return Sun, Mon, Tue, ... ... I would like to obtain that value for extensive (in another textbox ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: [RFC PATCH 16/22 -v2] add get_monotonic_cycles
    ... and I just blew away all my marker code for something like this;-) ... const char *format, ...) ... struct task_struct *prev; ...
    (Linux-Kernel)
  • Cannot copy. files on this CD are read only
    ... and now read only .Microsoft will not help,they pass me onto a tech line at ... My only solution might be to format and start over ... ..this is really pissing me off .Any ideas here ...Thanks ... Prev by Date: ...
    (microsoft.public.windowsxp.general)