Prev: Add record(s) automatically
Next: Functions not working
From: Darrell Childress on 25 Mar 2010 11:59
I have a form, one of the fields is called ShipDate. On this form, I
would like to have right beside the field a single letter (or 2 - Th for
Thursday) indicating the day of the week that the ShipDate is. For
example, if the ShipDate contained 3/22/10, right beside that I would
like a M (for Monday). I don't have a lot of room on the form to put the
whole thing (Monday)
Thanks,
Darrell
From: Darrell Childress on 25 Mar 2010 12:08
Never mind, I found it. Sorry, I got a little lazy and forgot to search
first.
I'm using =Format(ShipDate, "ddd")
I think I can live with 3 characters

On 3/25/10 11:59 AM, Darrell Childress wrote:
> I have a form, one of the fields is called ShipDate. On this form, I
> would like to have right beside the field a single letter (or 2 - Th for
> Thursday) indicating the day of the week that the ShipDate is. For
> example, if the ShipDate contained 3/22/10, right beside that I would
> like a M (for Monday). I don't have a lot of room on the form to put the
> whole thing (Monday)
> Thanks,
> Darrell

From: Arvin Meyer [MVP] on 25 Mar 2010 12:12
=Left(Format([ShipDate],"dddd"),2)

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Darrell Childress" <drc(a)nothing.com> wrote in message
news:%232X58PDzKHA.5036(a)TK2MSFTNGP02.phx.gbl...
>I have a form, one of the fields is called ShipDate. On this form, I would
>like to have right beside the field a single letter (or 2 - Th for
>Thursday) indicating the day of the week that the ShipDate is. For example,
>if the ShipDate contained 3/22/10, right beside that I would like a M (for
>Monday). I don't have a lot of room on the form to put the whole thing
>(Monday)
> Thanks,
> Darrell


From: Darrell Childress on 25 Mar 2010 12:24
Thank you Arvin, love these newsgroups!

On 3/25/10 12:12 PM, Arvin Meyer [MVP] wrote:
> =Left(Format([ShipDate],"dddd"),2)
>

From: John W. Vinson on 25 Mar 2010 12:41
On Thu, 25 Mar 2010 11:59:17 -0400, Darrell Childress <drc(a)nothing.com> wrote:

>I have a form, one of the fields is called ShipDate. On this form, I
>would like to have right beside the field a single letter (or 2 - Th for
>Thursday) indicating the day of the week that the ShipDate is. For
>example, if the ShipDate contained 3/22/10, right beside that I would
>like a M (for Monday). I don't have a lot of room on the form to put the
>whole thing (Monday)
>Thanks,
>Darrell

You don't even need a separate textbox. Just use a Format property such as

ddd d/m

to show

Thu 3/25

You can still type 3/25 or any other recognizable date; it will redisplay it
with the day name as soon as you leave the control.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Add record(s) automatically
Next: Functions not working