In Control Source of the textbox in form I have =Format([txtweekday];"dddd").
Return, for example, Sunday word.
Is possible to cut off the Sunday word to Sun?

Thanks in advance.
an

Change "dddd" to "ddd".
Did you copy and paste correctly? You need to have a comma char to seperate
the two arguments passed to the Format method.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"an" <(E-Mail Removed)> wrote in message
news:842E77B8-EFAC-4CDD-A120-(E-Mail Removed)...
>
> In Control Source of the textbox in form I have
> =Format([txtweekday];"dddd").
> Return, for example, Sunday word.
> Is possible to cut off the Sunday word to Sun?
>
> Thanks in advance.
> an

SL,
Thanks for your solution.
Work fine.
My paste is correct and work fine too...(?)

an

"Stephen Lebans" wrote:

> Change "dddd" to "ddd".
> Did you copy and paste correctly? You need to have a comma char to seperate
> the two arguments passed to the Format method.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "an" <(E-Mail Removed)> wrote in message
> news:842E77B8-EFAC-4CDD-A120-(E-Mail Removed)...
> >
> > In Control Source of the textbox in form I have
> > =Format([txtweekday];"dddd").
> > Return, for example, Sunday word.
> > Is possible to cut off the Sunday word to Sun?
> >
> > Thanks in advance.
> > an
>
>
>

"an" <(E-Mail Removed)> wrote in message
news:FFEB8FDF-F79F-498C-AC9C-(E-Mail Removed)
> SL,
> Thanks for your solution.
> Work fine.
> My paste is correct and work fine too...(?)

The list separator -- "," vs. ";" -- is a regional setting, I think.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Exact.
I think too.
My regional setting use ";" and not ","

an

"Dirk Goldgar" wrote:

> "an" <(E-Mail Removed)> wrote in message
> news:FFEB8FDF-F79F-498C-AC9C-(E-Mail Removed)
> > SL,
> > Thanks for your solution.
> > Work fine.
> > My paste is correct and work fine too...(?)
>
> The list separator -- "," vs. ";" -- is a regional setting, I think.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

Thanks Dirk
I need to get out of the country more often.
;-)

--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dirk Goldgar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "an" <(E-Mail Removed)> wrote in message
> news:FFEB8FDF-F79F-498C-AC9C-(E-Mail Removed)
>> SL,
>> Thanks for your solution.
>> Work fine.
>> My paste is correct and work fine too...(?)
>
> The list separator -- "," vs. ";" -- is a regional setting, I think.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>

Ok!
Cross the Atlântic and comes until Portugal :-)
Certainly you will be well received.

an

"Stephen Lebans" wrote:

> Thanks Dirk
> I need to get out of the country more often.
> ;-)
>
> --
>
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Dirk Goldgar" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > "an" <(E-Mail Removed)> wrote in message
> > news:FFEB8FDF-F79F-498C-AC9C-(E-Mail Removed)
> >> SL,
> >> Thanks for your solution.
> >> Work fine.
> >> My paste is correct and work fine too...(?)
> >
> > The list separator -- "," vs. ";" -- is a regional setting, I think.
> >
> > --
> > Dirk Goldgar, MS Access MVP
> > www.datagnostics.com
> >
> > (please reply to the newsgroup)
> >
> >
>
>
>