Re: Change number to extensive week day
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Assuming you mean you want to know the day in text, simply use the Format
function on the original date.
Format(MyDate, "ddd") will return Sun, Mon, Tue, ...
Format(MyDate, "dddd") will return Sunday, Monday, Tuesday, ...
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"an" <an@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7B0BC6A-976C-4C0F-9A18-953B52BDE2E0@xxxxxxxxxxxxxxxx
> Hello!
>
> I have a textbox were return us the number week day of the determined
> date.
> Now, I would like to obtain that value for extensive (in another textbox
> the
> corresponding word).
>
> Something it type:
> =IIf([Textbox1]=7;"SAT";Or[Textbox1]=1;"SUN";......)
>
> Thanks in advance.
> an
>
>
.
Relevant Pages
- Calculation
... I had a form that calculates 2 fields (on reality it has actualy a positive ... and negative values) i just change the format that will only show all the ... Now i need to sum it up (in different textbox) for all the ... Prev by Date: ...
(microsoft.public.access.forms) - Textbox property
... I am a beginner of VB.NET. ... textbox that only input numeric only or date format. ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb.controls) - Re: Different fontsize on same field based on length
... i may have figured it out...i moved the event procedure from the form ... to the details "on format" event procedure...i was looking for an event ... to program into the "title" textbox itself like on the form. ... Prev by Date: ...
(microsoft.public.access.reports) - Null Help!
... I have a form in Acces and have some textbox to enter date which will be ... insert to a field with date format in Access. ... Prev by Date: ...
(microsoft.public.access.modulesdaovba) - Re: Use TextBox Text As Function Name!
... the text in the TextBox changes to "<the name of the ... > OptionButton that was checked just before the selection change>2<the ... You have some design issues here. ... using the most common format. ...
(microsoft.public.vb.general.discussion) |
|
